-- Code Here
SELECT 
* 
FROM transactions
WHERE Customer LIKE 'D%' OR Customer LIKE 'E%'

-- Code Here
SELECT 
* 
FROM employees
WHERE salary > 5000000 AND months >= 12
ORDER BY salary 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 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 >= '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 id, name, age, kota FROM customers WHERE kota = 'Tasikmalaya'

-- Code Here
SELECT name, age FROM customers