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 ASC, total_price DESC;

-- Code Here
SELECT*FROM transactions
order by total_price DESC;

-- Code Here
SELECT*FROM transactions
order by total_price ASC;

-- Code Here
SELECT*FROM transactions
WHERE customer LIKE 'S%r';

SELECT*FROM transactions
WHERE customer is not NULL

SELECT*FROM transactions
WHERE customer is NULL

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

SELECT*FROM transactions

WHERE store IN ('BIE Store Bandung','BIE Store Palembang','BIE Store Malang')

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

SELECT*FROM transactions 
WHERE store='BIE Store Bandung' and total_price<= 100000;

SELECT*FROM customers
WHERE kota = 'Tasikmalaya';

SELECT name AS Nama,age AS Umur FROM customers;

SELECT name,age FROM customers