Project 2

Answer is attached below,

SELECT *
FROM orders a
WHERE purch_amt >
(SELECT AVG(purch_amt) FROM orders b
WHERE b.customer_id = a.customer_id);

SELECT SUM (month)
FROM orders;

SELECT COUNT(cities,group,name of cities)
FROM customer;