select 
  city_name, 
  sum(confirmed_cases) confirmed_cases , 
  sum(recovered_cases) recovered_cases, 
  sum(death_cases) death_cases
from cases
  join dati
  on dati.code = cases.dati_code
group by city_name
order by confirmed_cases desc;

select *
from employees
order by salary desc
limit 10

select *
from transactions
where customer is not null
order by store asc, total_price asc

select *
from transactions
order by total_price desc

SELECT *
FROM transactions
ORDER BY total_price ASC

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

SELECT *
FROM transactions
WHERE customer IS NOT NULL

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')

select date, store, total_price
from transactions
where date between '2022-01-01' and '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

-- Code here
select * from customers