Ad
mustain97vs.rishadharis

Basic Ordering 2 DESC (BIE)

Code
Diff
  • -- Code HerE
SELECT 
*
FROM Transactions
ORDER BY total_price DESC;
    • --- Code Here
    • -- Code HerE
    • SELECT
    • *
    • FROM Transactions
    • ORDER BY total_price DESC;
mustain97vs.rishadharis

Basic Ordering 1 ASC (BIE)

Code
Diff
  • -- Code Here
SELECT 
*
FROM Transactions
ORDER BY total_price;
    • --- Code Here
    • -- Code Here
    • SELECT
    • *
    • FROM Transactions
    • ORDER BY total_price;
mustain97vs.rishadharis

Basic Filtering 6 Like (BIE)

Code
Diff
  • -- Code Here
SELECT * FROM Transactions
WHERE customer LIKE 'S%r'
    • --- Code Here
    • -- Code Here
    • SELECT * FROM Transactions
    • WHERE customer LIKE 'S%r'
mustain97vs.rishadharis

Basic Filtering 8 Is Not (BIE)

Code
Diff
  • -- Code Here
SELECT * FROM Transactions
WHERE customer IS NOT NULL
    • --- Code Here
    • -- Code Here
    • SELECT * FROM Transactions
    • WHERE customer IS NOT NULL
mustain97vs.rishadharis

Basic Filtering 7 Is (BIE)

Code
Diff
  • -- Code Here
SELECT * FROM Transactions
WHERE customer IS NULL
    • --- Code Here
    • -- Code Here
    • SELECT * FROM Transactions
    • WHERE customer IS NULL
mustain97vs.rishadharis

Basic Filtering 5 Not In (BIE)

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')
mustain97vs.rishadharis

Basic Filtering 3 (BIE)

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'