Ad
Whitrisvs.luismba

Basic Ordering 3 Multiple Order (BIE)

Added table alias.

Code
Diff
  • -- Code Here
SELECT tra.total_price
FROM transactions AS tra
WHERE tra.Customer IS NOT NULL
ORDER BY tra.total_price DESC
    • -- Code Here
    • SELECT total_price
    • FROM transactions
    • WHERE Customer IS NOT NULL
    • ORDER BY total_price DESC
    • SELECT tra.total_price
    • FROM transactions AS tra
    • WHERE tra.Customer IS NOT NULL
    • ORDER BY tra.total_price DESC