Please answer these 5 questions based on this diagram

Database named OT which is based on a global fictitious company that sells computer hardware including storage, motherboard, RAM, video card, and CPU. The company maintains the product information such as name, description standard cost, list price, and product line. It also tracks the inventory information for all products including warehouses where products are available. Because the company operates globally, it has warehouses in various locations around the world. . The company records all customer information including name, address, and website. Each customer has at least one contact person with detailed information including name, email, and phone. The company also places a credit limit on each customer to limit the amount that customer can owe. 1. Create a view that selects customer details (Name & Address), Products ordered, Quantity ordered and total amount for all '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 ordered so far but not available in stock in any warehouse any more. (Query 3 Marks Output sreenshot-2 marks) 3. Write a query to display number of customers who are served orders by each employee on each date. Make sure to display subtotals for each employee and overall totals as well. (3 query + 2 Output screenshot) 4. Write a Query to print all warehouses and their locations from 'Asia Region sorted in descending order of warehouse name. (3 query + 2 Output screenshot) 5. Write a Query to print Employee name as well total Sales and Average sales of each employees. Make sure to round off numbers to 2 decimal places. (3 query + 2 Output| screenshot) Whenever a customer issues a purchase order, a sales order is created in the database with the pending status. When the company ships the order, the order status becomes shipped. In case the customer cancels an order, the order status becomes canceled. CUSTOMERS CUSTOMERUID NAME ADDRESS WEBSITE CREDIT LIMIT REGIONS REGIONULD REGION_NAME CONTACTS - CONTACTO FIRST NAME LAST NAME EMAIL PHONE CUSTOMERJD COUNTRIES COUNTRY D COUNTRY_NAME REGION_O [Hint- total amount of each order can be calculated using Quanit *unit price, which can be further used to calculate total and average sales] ORDERS ORDERO CUSTOMERUD STATUS SALESMANUD ORDER DATE EMPLOYEES EMPLOYEE D FIRST NAME LAST NAME EMAIL PHONE HIRE DATE MANAGER ID JOB_TITLE LOCATIONS - LOCATION_JD ADDRESS POSTAL CODE CITY STATE COUNTRY ORDER ITEMS -ORDERO ITEMID PRODUCT_JD QUANTITY UNT PRICE INVENTORIES PRODUCTO - WAREHOUSELO QUANTITY WAREHOUSES - WAREHOUSE ID WAREHOUSE_NAME LOCATIONID PRODUCTS PRODUCTJD PRODUCT NAME 44 DESCRIPTION STANDARD_COST LIST_PRICE CATEGORY_ID PRODUCT_CATEGORIES CATEGORY_JD CATEGORY NAME select * example > select * from otorders: Questions. 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 th * CATEGORY_ID CATEGORY_NAME