-- Code Here
select*from transactions where customer like 'S%r';

-- Code Here
select*from transactions
where customer is not NULL;

-- Code Here
select*from transactions
where customer is NULL;

-- Code Here
SELECT*FROM transactions
WHERE store Not in ('BIE Store Jakarta',
'BIE Store Bandung');

-- Code Here
SELECT*FROM transactions
WHERE store in ('BIE Store Bandung',
'BIE Store Palembang',
'BIE Store Malang') ;

-- Code Here
SELECT date,store,total_price 
FROM transactions
WHERE date >= '2022-01-01' AND date <= '2022-01-03'

-- Code Here
SELECT * FROM transactions
WHERE store = 'BIE Store Bandung' AND 
total_price <= 100000 ;

-- Code here
SELECT * FROM customers
WHERE kota = 'Tasikmalaya';

-- Code Here
SELECT name AS nama, age AS umur FROM customers;

-- Code Here
Select name, age From customers;