select * from transactions
where customer like 'D%' or customer like 'E%';

select * from employees
order by salary desc
limit 10;

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

select * from transactions 
order by total_price desc;

select * from transactions 
order by total_price;

select * from transactions
where customer like 'S%' and customer like '%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 customer is not null
order by store asc, total_price desc;

select * from transactions where store in ('BIE Store Bandung', 'BIE Store Palembang', 'BIE Store Malang');

select 
      date,
      store,
      total_price
from 
    transactions
where
      date
between
        '2022-01-01' and '2022-01-03';

select * from transactions where store = 'BIE Store Bandung' and total_price <= 100000;

select * from customers where Kota = 'Tasikmalaya';

select name, age from customers;