28Jan2020

--2.1
SELECT name, marital_status, income_level, birth_date
FROM XSALES.customers
WHERE name = 'Antony Chinn';

--2.2
SELECT id, promotion_id, channel
FROM XSALES.orders
WHERE customer_id = 14053;

--2.3
SELECT id, promotion_id, channel
FROM XSALES.orders
WHERE customer_id BETWEEN 10000 AND 15000
AND promotion_id = 999
AND channel = 'Internet';

--2.4
SELECT name, marital_status, xsales.orders.order_finished
FROM XSALES.customers JOIN XSALES.orders
ON XSALES.customers.id = XSALES.orders.id
WHERE marital_status = 'single'
AND credit_limit = 15000;

--2.5
SELECT xsales.promotions.name , COUNT(xsales.orders.id)
FROM xsales.promotions
JOIN xsales.orders
ON xsales.promotions.id = xsales.orders.promotion_id
GROUP BY xsales.promotions.name;