Ad
Code
Diff
  • -- Code Here
    SELECT 
    * 
    FROM transactions
    WHERE store NOT IN ('BIE Store Jakarta','BIE Store Bandung')
    • --- Code Here
    • -- Code Here
    • SELECT
    • *
    • FROM transactions
    • WHERE store NOT IN ('BIE Store Jakarta','BIE Store Bandung')
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 customers where kota ='Tasikmalaya'
    • --- Code here
    • -- Code here
    • select * from customers where kota ='Tasikmalaya'
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
  • select * from customers
    
    • -- Code here
    • select * from customers