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 using above er diagarm

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 using above er diagram

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 using above er diagram

CUSTOMERS CUSTOMER_ID NAME ADDRESS WEBSITE CREDIT_LIMIT REGIONS * REGION_ID REGION_NAME CONTACTS * CONTACT_ID FIRST_NAME LAST_NAME EMAIL PHONE CUSTOMER_ID COUNTRIES * COUNTRY_ID COUNTRY_NAME REGION_ID ORDERS * ORDER_ID CUSTOMER_ID STATUS SALESMAN_ID ORDER_DATE EMPLOYEES 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 * ITEM_ID PRODUCT_ID QUANTITY UNIT_PRICE INVENTORIES PRODUCT_ID * WAREHOUSE_ID QUANTITY WAREHOUSES * WAREHOUSE_ID WAREHOUSE_NAME LOCATION_ID PRODUCTS PRODUCT_ID PRODUCT_NAME DESCRIPTION STANDARD_COST LIST_PRICE CATEGORY_ID PRODUCT_CATEGORIES CATEGORY_ID CATEGORY_NAME