重命名的变量无法在where中使用
题目如下,
Write a SELECT statement that returns these column names and data from the Order_Items table:
item_id The item_id column
item_price The item_price column
discount_amount The discount_amount column
quantity The quantity column
price_total A column that’s calculated by multiplying the item price by the quantity
discount_total A column that’s calculated by multiplying the discount amount by the quantity
item_total A column that’s calculated by subtracting the discount amount from the item price and then multiplying by the quantity
Only return rows where the item_total is greater than 500. Sort the result set by item total in descending sequence.
就是在select
中重命名的变量,想要用到where
里去,没有想到报错了
Error Code: