If I change the WHERE clause by:
WHERE order_id = ‘6’ AND total_price > ‘30’
I do not get an answer.
The original data doesn’t include the total_price column but I created one using the Select clause.
After that when I try to use the total_price column in the WHERE condition, it doesn’t work until I use the actual data (unit_price * quantity). Why is this so?