Ad
Code
Diff
  • -- Code HerE
    SELECT 
    *
    FROM Transactions
    ORDER BY total_price DESC;
    • --- Code Here
    • -- Code HerE
    • SELECT
    • *
    • FROM Transactions
    • ORDER BY total_price DESC;
Code
Diff
  • -- Code Here
    SELECT 
    *
    FROM Transactions
    ORDER BY total_price;
    • --- Code Here
    • -- Code Here
    • SELECT
    • *
    • FROM Transactions
    • ORDER BY total_price;
Code
Diff
  • -- Code Here
    SELECT * FROM Transactions
    WHERE customer LIKE 'S%r'
    • --- Code Here
    • -- Code Here
    • SELECT * FROM Transactions
    • WHERE customer LIKE 'S%r'
Code
Diff
  • -- Code Here
    SELECT * FROM Transactions
    WHERE customer IS NOT NULL
    • --- Code Here
    • -- Code Here
    • SELECT * FROM Transactions
    • WHERE customer IS NOT NULL
Code
Diff
  • -- Code Here
    SELECT * FROM Transactions
    WHERE customer IS NULL
    • --- Code Here
    • -- Code Here
    • SELECT * FROM Transactions
    • WHERE customer IS NULL
Code
Diff
  • -- Code Here
    SELECT * FROM Transactions
    WHERE Store NOT IN ('BIE Store Bandung','BIE Store Jakarta')
    • --- Code Here
    • -- Code Here
    • SELECT * FROM Transactions
    • WHERE Store NOT IN ('BIE Store Bandung','BIE Store Jakarta')
Code
Diff
  • -- Code Here
    SELECT date, store, total_price
    FROM transactions
    WHERE date >= '2022-01-01' AND date<='2022-01-03'
    
    • --- Code Here
    • -- Code Here
    • SELECT date, store, total_price
    • FROM transactions
    • WHERE date >= '2022-01-01' AND date<='2022-01-03'