1. Display all of the products that each customer is buying.
*I assume that you want get the list of all the product that bought by each customer.
SELECT c_id, p_name
FROM PRODUCT
GROUP BY c_id
2. Using question(1) display how many customers are from each state from this query.
SELECT p.p_name, c.state
FROM PRODUCT p JOIN CUSTOMER c
ON p.c_id = c.c_id
Anyway, the tables don't fulfill the Normalization.
You should separate the into 3 tables, which are Customers, Products and Orders. Don't store the Products and the Orders into 1 table. Because if you delete the product, then the Orders' data will be gone too.
Hope this helps.