Write following SQL Queries: 1.List the order number, order date, customer number, customer name (first and last), employee number, and employee name (first and last) of January 2017orders placed by Colorado customers.

2.List the customer number, name (first and last), order number, order date, employee number, employee name (first and last), product number, product name, and order cost (OrdLine.Qty * ProdPrice)for products ordered on January 23, 2017, in which the order cost exceeds $150.

3.List the order number and total amount for orders placed on January 23, 2017. The total amount of an order is the sum of the quantity times the produ

ct price of each product on the order.

4.List the order number, order date, customer name (first and last), and total amount for orders placed on January 23, 2017. The total amount of an order is the sum of the quantity times the product price of each product on the order.

*Note: Use the Relational Schema given on next page in order to write above SQL Queries*

Relational Schema CUSTOMER CUSTNO CHAR (8 BYTE) CUSTFIRSTNAME VARCHAR2 (20 BYTE) - CUSTLASTNAME VARCHAR2 (30 BYTE) CUSTSTREET VARCHAR2 (50 BYTE) CUSTCITY VARCHAR2 (30 BYTE) CUSTSTATE CHAR (2 BYTE) CUSTZIP CHAR(10 BYTE) CUSTBAL NUMBER (12.2) EMPLOYEE PEMPNO CHAR (8 BYTE) EMPFIRSTNAME VARCHAR2 (20 BYTE) EMPLASTNAME VARCHAR2 (30 BYTE) EMPPHONE CHAR (15 BYTE) U EMPEMAIL VARCHAR2 (50 BYTE) F SUPEMPNO CHAR (8 BYTE) EMPCOMMRATE NUMBER (3.3) 1 ORDERTBL ORDNO CHAR (8 BYTE) ORDDATE DATE F CUSTNO CHAR (8 BYTE) F EMPNO CHAR (8 BYTE) ORDNAME VARCHAR2 (50 BYTE) ORDSTREET VARCHAR2 (50 BYTE) ORDCITY VARCHAR2 (30 BYTE) ORDSTATE CHAR (2 BYTE) ORDZIP CHAR(10 BYTE) PF ORDNO PF PRODNO QTY ORDLINE CHAR (8 BYTE) CHAR (8 BYTE) NUMBER (0) PRODUCT PRODNO CHAR (8 BYTE) PRODNAME VARCHAR2(50 BYTE) PRODMFG VARCHAR2 (20 BYTE) PRODOOH NUMBER (0) PRODPRICE NUMBER (12,2) PRODNEXTSHIPDATE DATE A