Project 1

1.SELECT * FROM customers ORDER BY city;

2.ALTER Table customers Rename id to prod_id

3.SELECT customer_name, COUNT(DISTINCT product_ID) as products_count FROM customer_table
INNER JOIN orders_table ON customer_table.customer_ID = orders_table.customer_ID
GROUP BY customer_table.customer_ID, customer_name
HAVING COUNT(DISTINCT product_ID) > 10

4.SELECT customer_name, COUNT(DISTINCT product_ID) as products_count FROM customer_table WHERE customer.name="%A%"INNER JOIN orders_table ON customer_table.customer_ID = orders_table.customer_ID GROUP BY customer_table.customer_ID, customer_name HAVING COUNT(DISTINCT product_ID) > 10

5.SELECT orders.status , order.amount from order where order.status="Success" and order.amount>10000

6.