q:

Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_DD SALESMAN DELIVERY_DATE NAME 1001 300 05-03-2017 2001 AJI 05-05-2017 1002 200.20 10-07-2017 2002 SHALA 10-10-2017 1003 600 12-06-2017 2005 KABIR 12-08-2017 1004 400.25 10-05-2017 2003 AKBAR 10-07-2017 1005 500.10 03-08-2017 2004 BABER 03-05-2017 1006 400 10-07-2017 2005 HUSAIN 10-10-2017 a) Write an SQL query to display the ORDER_NO and ORDER_DATE from PURCHASE_ORDER table who order the products between 05-03-2017 and 01-06-2017 b) Develop an SQL query to display the ORDER_NO, SALESMAN_NAME and extract the first three letters of ORDER_NO. Give an alias Name PRO_ORDER. from the table PURCHASE ORDER. c) Write an SQL query to display the ORDER_NO, DELIVERY_DATE and find the average of amount, also group the records based on ORDER_NO. (Hint: Use PURCHASE_ORDER table]. d) Develop an SQL query to display the unique ORDER_NO and CUSTOMER_ID for those SALEAMAN NAME ends with letter R. (Hint: PURCHASE _ORDER Table]