I need some help with homework for my class on SQL. This question uses the PineValleyFurn Database, but I'll attach screenshots of the tables.

The question is

1) List customer ID, customer name, order ID, order date, product ID and the quantity of each product ordered, for all customers who have placed orders.

b) List customer ID, customer name, order ID, order date, product name, quantity ordered, and price of each product, for all customers who have placed orders.

c) List the customer name, city, and state of customers who ordered products 3 or 4.

Order ID Order Date Customer ID 1001 1002 10/21/2008 1003 10/22/2008 1004 10/22/2008 1005 10/24/2008 1006 10/24/2008 1007 10/27/2008 1008 10/30/2008 1009 11/5/2008 1010 11/5/2008 10/21/2008 8 15 5 3 12 4 1