SELECT
  b.city_name kota,
  SUM(a.confirmed_cases) confirmed_cases,
  SUM(a.recovered_cases) recovered_cases,
  SUM(a.death_cases) death_cases
FROM
  cases a
JOIN 
  dati b
ON a.dati_code = b.code
GROUP BY
  kota
ORDER BY
  confirmed_cases DESC

-- Code Here
SELECT *
FROM transactions
WHERE customer IS NOT NULL
ORDER BY store, total_price DESC

SELECT *
FROM transactions
WHERE customer IS NULL

SELECT *
FROM transactions
WHERE store NOT IN ('BIE Store Jakarta','BIE Store Bandung')

SELECT 
  date, 
  store, 
  total_price 
FROM 
  transactions
WHERE 
  date BETWEEN '2022-01-01' AND '2022-01-03'