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

Name		Name	Last commit message	Last commit date
parent directory ..
Create_table_dept.sql		Create_table_dept.sql
Create_table_emp.sql		Create_table_emp.sql
Create_table_salgrade.sql		Create_table_salgrade.sql
Insert_dept.sql		Insert_dept.sql
Insert_emp.sql		Insert_emp.sql
Insert_salgrade.sql		Insert_salgrade.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
Query_11.sql		Query_11.sql
Query_12.sql		Query_12.sql
Query_13.sql		Query_13.sql
Query_14.sql		Query_14.sql
Query_15.sql		Query_15.sql
Query_16.sql		Query_16.sql
dept.csv		dept.csv
emp.csv		emp.csv
readme.md		readme.md
salgrade.csv		salgrade.csv

readme.md

Nested Queries with SQL Clauses

Queries

Display the name of employee who earns maximum salary.
Display the name of employee who earns maximum salary whose job is salesman.
Display the name of employee who earns minimum salary and whose job is clerk.
Display the department whose average salary is maximum.
List the name of the employee whose salary is more than 'TURNER'.
List the name of employee who joined after ALLEN.
Display the name of the department in which 'FORD' works.
Display the name of the department whose salary is maximum.
Display the name of the city(location) in which 'SMITH' works.
Display the name of the city in which the manager works.
Display the grade of the employee named 'MARTIN'.
List the employees who earns more than every employee in 'DALLAS'.
Display the name of the department which has no employee.
List the name of the employee who joined in the same date of 'ADAMS'.
List the name of the department who gets commission.
List the employees who earn the lowest salary in their respective department.