Question: 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 ORDERORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN DELIVERY_DATE NAME 1001 300 05-03-2017 2001 AJI

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Refer the given tables and answer the question that follow: 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...

Q:

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...

Q:

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...

Q:

Refer the given tables and answer the question that follow: Table: PURCHASE ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN DELIVERY_DATE NAME 1001 300 05-03-2017 2001 AJI OS-05-2017 1002...

Q:

AJI Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN DELIVERY_DATE NAME 1001 300 05-03-2017 2001 05-05-2017 1002 200.20 10-07-2017 2002 SHALA 10-10-2017 1003 600 12-06-2017 2005...

Q:

con 300 Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN_DELIVERY_DATE NAME 1001 05-03-2017 2001 AJI 05-05-2017 1002 200.20 10-07-2017 2002 SHALA 10-10-2017 1003 600 12-06-2017...

Q:

PLEASE HELP I HAVE ONE HOURE TO SOLVE IT Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN_ID DELIVERY_DATE 1001 300 05-03-2017 2001 3001 05-05-2017 1002 200.20 10-07-2017 2002...

Q:

Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER DATE CUSTOMER_ID SALESMAN_ID DELIVERY_DATE 1001 300 05-03-2017 2001 3001 05-05-2017 1002 200.20 10-07-2017 2002 3003 10-10-2017 1003 600 12-06-2017 2005...

Q:

Table : PURCHASE_ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN_ID DELIVERY_DATE 1001 300 05-03-2017 2001 3001 05-05-2017 1002 200.20 10-07-2017 2002 3003 1003 600 12-06-2017 2005 3002...

Q:

Table : PURCHASE ORDER ORDER_NO AMOUNT ORDER_DATE CUSTOMER_ID SALESMAN_ID DELIVERY_DATE 300 200.20 600 1001 1002 1003 1004 1005 1006 05-03-2017 10-07-2017 12-06-2017 10-05-2017 03-08-2017 10-07-2017...

Q:

Using the compressor described in previous problem, 4-1-90[BCG], plot how the shaft power (Wsh) varies with input pressure (p1) varying from 100 kPa to 600 kPa, all other input parameters remaining...

Q:

The following information applies to the questions displayed below.] The following refers to units processed in Sunflower Printing's binding department in March. Units of ProductPercent of Conversion...

Q:

1. Write a program that uses the variables below and MOV instructions to copy the value from bigEndian to littleEndian, reversing the order of the bytes. The numbers 32-bit value is understood to be...

Q:

Classify each of the following performance measures into the balanced scorecard perspective to which it relates: financial perspective, internal operations perspective, learning and growth...

Q:

1. To identify the programs strengths and weaknesses. This includes determining if the program is meeting the learning objectives, if the quality of the learning environment is satisfactory, and if...

Q:

4. Cost justification for training is based on numerical indicators. (Here the company has a strong orientation toward evaluation.)

Q:

2. To assess whether the content, organization, and administration of the program including the schedule, accommodations, trainers, and materialscontribute to learning and the use of training content...