SELECT * FROM employees ORDER BY employees.salary desc LIMIT 10

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

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

SELECT * FROM customers 
WHERE customers.kota='Tasikmalaya'

SELECT customers.name, customers.age FROM customers

SELECT customers.name nama, customers.age umur FROM customers

SELECT * FROM customers

select * from employees where employees.salary>5000000 and employees.months>=12
order by employees.salary desc

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

select * from transactions
order by total_price desc

select * from transactions

order by transactions.total_price asc