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

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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

SQL SQL Provide the StayWell Property Management team with a list of all property addresses combined with the name of the owners. here is what i have so far but says query completed but nothing shows SELECT O.FIRST_NAME, O.LAST_NAME,P.ADDRESS FROM OWNER AS O,PROPERTY AS P two tables im grabbing the information from are attached owner table and property expected outcome FIRST_NAME LAST_NAME ADDRESS Ernest Burke 30 West Thomas Rd. Ceyda Aksoy 782 Queen Ln. Nicole Bianchi 9800 Sunbeam Ave. Jakub Kowalczyk 105 North Illinois Rd. Haydon Sims 887 Vine Rd. Elle-May Moore 8 Laurel Dr. Meerab Cole 447 Goldfield St. Jakub Kowalczyk 594 Leatherwood Dr. Makesh Patel 504 Windsor Ave. Janine Lopez 891 Alton Dr. Ammarah Jones 9531 Sherwood Rd. Seth Redman 2 Bow Ridge Ave. Haydon Sims 916 Kent Drive
Let’s say you have two SQL tables: authors and books The authors dataset has 1M+ rows; here’s the first six rows:author_name book_name author_1 book_1 author_1 book_2 author_2 book_3 author_2 book_4 author_2 book_5 author_3 book_6……The books dataset also has 1M+ rows and here’s the first six:book_name sold_copies book_1 1000 book_2 1500 book_3 34000 book_4 29000 book_5 40000 book_6 4400……Create an SQL query that shows the TOP 3 authors who sold the most books in total!
USE this part to write SQL statements at the bottom questions 1-11 Branch(branch_id:integer, branch_name:varchar(50), branch_location:varchar(40), money_on_hand:numeric(15,2) create table Branch (branch_id integer, branch_name varchar(50), branch_location varchar(40), money_on_hand numeric(15,2), primary key (branch_id)); Loan(loan_number:integer, branch_id:integer, amount:numeric(8,2)) foreign key branch_id references Branch(branch_id) create table Loan (loan_number integer, branch_id integer, amount numeric(8,2), primary key (loan_number), foreign key (branch_id) references Branch (branch_id)); Customer(customer_id:integer, customer_last_name:varchar(35),customer_first_name:varchar(25), customer_street:varchar(30),…
Make the following tables database:
Sql
Table no. 1 only
Create the order table.
How do global temporary tables differ from local temporary tables in SQL Server, and when might each be used?
Write a query to display the name of the department that has the maximum staff count order by department name. Refer the below schema diagram: College Management System(CMS) Department Student department id number-- PK department_name varchar(30) department_block_number number O4student_id number --> PK student_name varchar(30) address varchar(40) city varchar(30) department_id number --> FK PK-- Primary Key FK-- Foreign Key Subject Staff subject_id number -PK subject_name varchar(30) subject_code varchar(10) staff_id number -- FK staff_id number --> PK staff_name varchar(30) 王 department_id number--> FK Mark value number subject_id number--> PK,FK + student_id number-->PK,FK 王
Write a sql query to create the following table.