provide Observations and Insights on this data: - Question 1: -- Find the total number of customers who have placed orders. What is the distribution of the customers across states? [4 marks] -- Hint: For each state, count the number of customers SELECT c.state, o.order_id, COUNT(DISTINCT c.customer_id) AS cust_count FROM customer_t AS c JOIN order_t AS o USING (customer_id) GROUP BY c.state ORDER BY c.state;

Result: Passed Query 1 Query: SELECT c.state, o.order_id, COUNT(DISTINCT c.customer_id) AS customer_count FROM customer_t AS c JOIN order_t AS o USING (customer_id) GROUP BY c.state ORDER BY c.state ASC Output: Showing first 10 rows out of 49 rows state order_id customer_count Alabama 0113-0166 29 Alaska 0268-6694 10 Arizona 0185-0055 26 Arkansas 30142-246 6 California 0067-6025 97 Colorado 0049-0032 33 Connecticut 0173-0842 22