Answered step by step
Verified Expert Solution
Question
1 Approved Answer
HELP QUEQLY PLEASE,I HAVE ONLY ONE HOUR. Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN DELIVERY_DATE NAME 1001 300 05-03-2017 2001 AJI 05-05-2017 1002
HELP QUEQLY PLEASE,I HAVE ONLY ONE HOUR.
Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID 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 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]Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started