Homework 2 Write SQL queries for the Pine Valley Furniture Company Database to answer the following questions:

1. Write a SQL query to display order ID and order date for all the orders made by customers in the territory of Southwest (use WHERE command to join tables). .

2. Use sub-query technique to write a SQL query to display order ID and order date for all the orders made by customers in the territory of Southwest.

3. What are the product ID and product description for the products with a price larger than the price of the product Computer Desk?

4. What are the order IDs of the orders that have included the product with the largest price?

5. Give 10% discount to all the products manufactured by the product line 3.

Re EMPLOYEEt VEmployeeJD CUST... Table Date Create.. Date Modifi Does.. Table Date Create. Date Modifi Empl... Table Date Create Date Modifi. EMPL. Table EMPLOYEEt 1 Employee Skills Employee-ld Skill l ORDER t -1 Employe- SKILL t Skill ld Skill Description Employee City Employee State Cut Employe Does Bu. Produced inEmolovee Supe TERRITORY t Territory ID Territory Order line t Date Create... Date Modifi WORK CENTER Work Center ID Works in Product,ID Ordered Order... Table Employee Id Work-Center-Id Work Center SALESPERSON ? Salesperson-ID SalesPerson N Date Create.. Date Modifi VENDOR t Vendor ID Vendor, Name Vendor Address Vendor City Vendor State Vendor Zipcode ORDE... Table Date Create SUPPLIES t Date Modifi Produ...T Date Create Salesperson-Fax ? Vendor Id Material Id Supply Unit Price PRODUCT LINE Product Line ID Product Line Name PROD... Table Date Create... Date Modifi PROD... Table Date Create... Date Modif RAWTable Date Create. Date Modifi RAW MATERIAL Material JD Material Name Unit Of Measure Standard Cost Uses PRODUCTt Product ID Product Material Id Goes into Quantity SALESTable Date Create. Date Modifi Standard P SKILL t Table Date Create. Date Modifs SUPP Table Date Create