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

1. Use WHERE command to join tables and write a query to display Order_ID and Order_Date for all the orders made by customers in the territory of Southeast (i.e., Territory_Name= Southeast).

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 Southeast.

3. Give 15% discount to all the products manufactured by the product line Scandinavia (i.e., Product_Line_Name= Scandinavia).

4. What are the Product_ID and Product_Description for the products with a price larger than the price of the product Writers Desk?

5. What are the Customer_Name(s) of the customers who have ordered the product with the lowest price?

CUSTOMER t EMPLOYEE SKILL t Employee_Skills_t | Employee-d Customer-ID Customer_Name Customer Address Customer City Customer State Postal Code ORDER t Employee ID Employee Name Employee Address Employee City Employee State Employee Zipcode Employee Supervisor Date Hired Skill-Id Skill_Description Order,ID Order Date Customer ID EMPLOYEE t 1 Employee ID TERRITORY t Does Business_In t Territory ID Territory_Name Customer Id Employee Addr Employee City- Employee State Employee Zipc Territory.ld Produced in t WORK CENTER product-Id Work Center Id Works in Work_Center ID Work Center_Location Employee_Id coWork_Center_Id Date Hired Order line t Order TD Product ID Ordered_Quantity SALESPERSON t VENDOR t Salesperson-ID ? Vendor ID SUPPLIESt SalesPerson Name SalesPerson_phone SalesPerson_Fax Territory Id Vendor Name Vendor Address Vendor_City Vendor State Vendor Zipcode Vendor_Id Materiald Supply_Unit Price RAW MATERIAL t Material_IO Material_Name Unit_Of Measure Standard_Cost PRODUCT t PRODUCT LINE t Uses Product Description Product Finish Standard Price Product Line ID Product-Id Material_Td Goes_into_Quantity Product Line_ID Product Line_Name