-- Code Here

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

  

-- Code Here
select * 
from employees
order by salary desc
limit 10

-- Code Here

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

-- Code Here
select * 
from transactions
order by total_price 

-- Code Here
select * 
from transactions
where customer like 'S%'
and customer like '%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 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