PLEASE SOLVE ACCORDINGLY ITS THE 3RD TIME I'M POSTING THE SAME QUESTION NO ONE ANSWERED IT CORRECTLY. JUST COPY PASTING THE MATERIAL

CUSTOMERS CUSTOMERJID NAME ADDRESS WEBSITE CREDIT LIMIT REGIONS REGION_ID REGION_NAME CONTACTS - CONTACT_ID FIRST_NAME LAST_NAME EMAIL PHONE CUSTOMER_ID COUNTRIES COUNTRY_JD COUNTRY_NAME REGION_ID ORDERS ORDERJID CUSTOMERJID STATUS SALESMANLID ORDER_DATE EMPLOYEES et EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE HIRE DATE MANAGER ID JOB_TITLE LOCATIONS - LOCATION_ID ADDRESS POSTAL CODE CITY STATE COUNTRY_ID ORDER ITEMS -ORDER ID -ITEMID PRODUCT_JD QUANTITY UNIT_PRICE INVENTORIES - PRODUCT_ID WAREHOUSE_ID QUANTITY WAREHOUSES - WAREHOUSE_ID WAREHOUSE_NAME LOCATION_D PRODUCTS .PRODUCT_ID PRODUCT_NAME DESCRIPTION STANDARD_COST LIST PRICE CATEGORY_ID PRODUCT_CATEGORIES - CATEGORY_ID CATEGORY_NAME 1. Create a view that selects customer details (Name & Address), Products ordered, Quantity ordered and total amount for all 'Cancelled' and 'Pending orders of 2015. (Hint;- total amount can be calculated using Quanity*unit.price] 2. Using set Operations, list all the Product names which were either ordered or which are not ordered so far but available in stock in any warehouse. Make sure product names are unique. 3. Write a query to display number of customers who are served orders by each employee on each date. Make sure to display subtotals using all possible combinations using sets query 4. Write a Query to print all warehouses and their locations in all regions sorted in descending order of warehouse name