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

Related questions

Q: Creating a table with following information: Name of table: Worker, columns and data types:…

A: The CREATE TABLE statement is used to create a new table in a database.

Q: Write SQL Queries for following Employee table : EMPLOYEE_ID Name EMAIL HIRE DATE SALARY DEPARTMENT…

A: The name of the given table is Employee. It has six columns named EMPLOYEE_ID, Name, EMAIL,…

Q: Given the default schema of a database: Customers 123 Customerld ADC FirstName ADC LastName ADC City…

A: Answer: We need to write the given SQL command what will be return so we will see in the more…

Q: Given the default schema of a database: EB Orders 123 Orderld OrderDate ADC OrderNumber 123…

A: The question has been answered in step2

Q: Write an SQL query to find the manufacturer and model for all aircraft models with capacity at least…

A: The query is

Q: From each sales rep, list the rep number, description, number ordered and storehouse from their…

A: Select rep.rep_num, itm.description, ord.order_num,item.storehousefrom rep rep,customer cust, orders…

Q: Write an SQL query for printing the details of DEPARTMENT name as "Admin". WORKER_ID FIRST_NAME…

A: Given, Table:

Q: Use given tables as reference Write a SQL query to print details of the Workers whose SALARY…

A: Q 1. Write a SQL query to print details of the Workers whose SALARY lies between 100000 and 500000.…

Q: an SQL query to find the names of the airlines that have at least 10 Boeing 737 in their fleet.

A: The above given question is to write the SQL query to extract the names of airlines that have…

Q: use the following picture to answer the question below Assuming Order table already exist, add a…

A: To add a Foreign Key Constraint to an already existing table, the below query syntax is used. ALTER…

Q: (a) Write a complete PL/SQL Cursor to retrieve the following information. Fetch row number, Employee…

A: Question (a) DECLARERow_Number Numeric(10);E_ID employees.employee_id%type;E_FName…

Q: Consider the following table employees (employee_id, first name, last name, email, phone number,…

A: Given that, the name of the table is employees. employee table attributes: employee_id, first_name,…

Q: The Car Maintenance team considered that the available maintenance tasks should also have the price…

A: TASK 1: -- Creating a new table MAINTENANCE_TYPES with following fields create table…

Q: Figure Q3.16b The CUSTOMER and CAR Tables Database name: Ch03_Questions Table name: CUSTOMER Table…

A: Attributes are the properties or characteristics of entities. Relationships describe how entities…

Q: ansactions sender receiver amount transaction_date 10 2 2-12-20 2-13-20 2-13-20 15 20 25 20 2-14-20…

A: Here have to determine sql query for creating table.

Q: using oracle

A: write sql query to display item name, item price , customer name.

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

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),…
Sql
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 sql query to create the following table.