Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

SQL Antipatterns Avoiding The Pitfalls Of Database Programming

Authors: Bill Karwin

1st Edition

1680508989, 978-1680508987

More Books

Students also viewed these Databases questions

Question

Q 11.4. How does an efficient market differ from a perfect market?

Answered: 1 week ago

Question

What is your least favorite U.S. dialect? Why?

Answered: 1 week ago

Question

LO2 Compare three types of individual incentives.

Answered: 1 week ago