MySQL | Error Code: 1292. Truncated incorrect DOUBLE value: '149.89'
From sourcetable "amazon_order_history_2022" and column "Betrag" (datatype: varchar) I want to calculate a new column, that classifies data from column "Betrag", wether it smaller/equal to 100 or bigger than 100. So far the code is working. Then I want to…