Ad
Code
Diff
  • select * from transactions 
    where store not in ('BIE Store Jakarta','BIE Store Bandung')
    -- Code Here
    • select * from transactions
    • where store not in ('BIE Store Jakarta','BIE Store Bandung')
    • -- Code Here
Code
Diff
  • -- Code Here
    SELECT *
    FROM TRANSACTIONS 
    WHERE store IN ('BIE Store Bandung','BIE Store Malang','BIE Store Palembang')
    • --- Code Here
    • -- Code Here
    • SELECT *
    • FROM TRANSACTIONS
    • WHERE store IN ('BIE Store Bandung','BIE Store Malang','BIE Store Palembang')
Code
Diff
  • -- Code Here
    SELECT date, store, total_price
    FROM transactions
    WHERE date BETWEEN '2022-01-01' AND '2022-01-03'
    • --- Code Here
    • -- Code Here
    • SELECT date, store, total_price
    • FROM transactions
    • WHERE date BETWEEN '2022-01-01' AND '2022-01-03'
Code
Diff
  • -- Code Here
    SELECT * FROM transactions WHERE store = 'BIE Store Bandung' and total_price <= 100000
    • --- Code Here
    • -- Code Here
    • SELECT * FROM transactions WHERE store = 'BIE Store Bandung' and total_price <= 100000
Code
Diff
  • -- Code Here
    SELECT name AS nama, age as umur from customers
    • --- Code Here
    • -- Code Here
    • SELECT name AS nama, age as umur from customers
Code
Diff
  • -- Code Here
    SELECT name, age from CUSTOMERS
    • --- Code Here
    • -- Code Here
    • SELECT name, age from CUSTOMERS
Code
Diff
  • -- Code here
    SELECT * FROM CUSTOMERS
    • -- Code here
    • SELECT * FROM CUSTOMERS