SQL-Database-Management-System/Day-05 Nested Queries at main · Adrish1999/SQL-Database-Management-System · GitHub

Name		Name	Last commit message	Last commit date
parent directory ..
Create_customers.sql		Create_customers.sql
Create_employees.sql		Create_employees.sql
Create_odetails.sql		Create_odetails.sql
Create_orders.sql		Create_orders.sql
Create_parts.sql		Create_parts.sql
Create_zipcodes.sql		Create_zipcodes.sql
Insert_customers.sql		Insert_customers.sql
Insert_employees.sql		Insert_employees.sql
Insert_odetails.sql		Insert_odetails.sql
Insert_orders.sql		Insert_orders.sql
Insert_parts.sql		Insert_parts.sql
Insert_zipcodes.sql		Insert_zipcodes.sql
Query_01.sql		Query_01.sql
Query_02.sql		Query_02.sql
Query_03.sql		Query_03.sql
Query_04.sql		Query_04.sql
Query_05.sql		Query_05.sql
Query_06.sql		Query_06.sql
Query_07.sql		Query_07.sql
Query_08.sql		Query_08.sql
Query_09.sql		Query_09.sql
Query_10.sql		Query_10.sql
customers.csv		customers.csv
employees.csv		employees.csv
odetails.csv		odetails.csv
orders.csv		orders.csv
parts.csv		parts.csv
readme.md		readme.md
zipcodes.csv		zipcodes.csv

readme.md

Nested Queries

Queries

Get PNO & PNAME values of parts that are priced less than 20.
Get PNO values for parts for which orders have been placed.
Get all the details of customers whose names begin with the letter "S".
Get the ONO & CNAME values for customers whose orders have not yet been shipped.
Get CNAME & ENAME pairs such the customer with name CNAME has placed and ordered through the employees with name ENAME.
Get the name of employees who was hired on the earliest date.
Retrieve the part number, part name and price of parts with price greater than 2000 in an ascending order of part number.
For each part, get PNO & PNAME values along with total sales.
Get the total quantity of parts 10601 that has been ordered.
Get the ENO values of employees from city "Mumbai".