select
customer_id, product_id, sales, quantity
from tokopaedi.orders;
select * from tokopaedi.orders limit 5;
select * from tokopaedi.orders order by profit desc limit 5;
select distinct(subcategory) from tokopaedi.orders;
select * from tokopaedi.orders where category = 'Office Supplies';
select * from tokopaedi.orders where city = 'Iowa City' or city = 'Waterloo';
select * from tokopaedi.orders where segment = 'Corporate' and category='Office Supplies' and city='Los Angeles';
select * from tokopaedi.orders;
select * from tokopaedi.orders where profit > 0;
select order_id, customer_name, product_name, profit from tokopaedi.orders where quantity >=10 and profit < 0;
select * from tokopaedi.orders where city in('Los Angeles', 'Lehi', 'Orem', 'Logan', 'Bangor');
select * from tokopaedi.orders where city in('Los Angeles', 'Lehi', 'Orem', 'Logan', 'Bangor') and profit < 0;
select * from tokopaedi.orders where city in('Los Angeles', 'Lehi', 'Orem', 'Logan', 'Bangor') and profit > 1000;
select * from tokopaedi.orders where city not in('Los Angeles', 'Lehi', 'Orem', 'Logan', 'Bangor');
select * from tokopaedi.orders where order_date >= '2016-01-01';
select * from tokopaedi.orders where order_date >= '2017-01-01' and order_date <= '2017-12-31';