PostgreSQL Subquery - Exercises, Practice, Solution

Last update on March 23 2024 12:26:51 (UTC/GMT +8 hours)

PostgreSQL Subquery [21 exercises with solution]

1. Write a query to find the first_name, last_name and salaries of the employees who have a higher salary than the employee whose last_name is Bull.

Sample table: employees

Click me to see the solution

2. Write a SQL subquery to find the first_name and last_name of all employees who works in the IT department.

Sample table: employees

Click me to see the solution

3. Write a SQL subquery to find the first_name and last_name of the employees under a manager who works for a department based in the United States.

Hint : Write single-row and multiple-row subqueries

Sample table: employees

Sample table: departments

Sample table: locations

Click me to see the solution

4. Write a SQL subquery to find the first_name and last_name of the employees who are working as a manager.

Sample table: employees

Click me to see the solution

5. Write a SQL subquery to find the first_name, last_name and salary, which is greater than the average salary of the employees.

Sample table: employees

Click me to see the solution

6. Write a SQL subquery to find the first_name, last_name and salary, which is equal to the minimum salary for this post, he/she is working on.

Sample table: employees

Sample table: jobs

Click me to see the solution

7. Write a SQL Subquery to find the first_name, last_name and salary of the employees who earn more than the average salary and works in any of the IT departments.

Sample table: employees

Sample table: departments

Click me to see the solution

8. Write a SQL subquery to find the first_name, last_name and salary of the employees who draw a more salary than the employee, which the last name is Bell.

Sample table: employees

Sample table: departments

Click me to see the solution

9. Write a SQL subquery to find all the information of the employees who draws the same salary as the minimum salary for all departments.

Sample table: employees

Sample table: departments

Click me to see the solution

10. Write a SQL subquery to find all the information of the employees whose salary greater than the average salary of all departments.

Sample table: employees

Click me to see the solution

11. Write a subquery to find the first_name, last_name, job_id and salary of the employees who draws a salary that is higher than the salary of all the Shipping Clerk (JOB_ID = 'SH_CLERK'). Sort the results on salary from the lowest to highest.

Sample table: employees

Click me to see the solution

12. Write a query to find the names (first_name, last_name) of the employees who are not supervisors.

Sample table: employees

Click me to see the solution

13. Write a SQL subquery to find the employee ID, first name, last name and department names of all employees.

Sample table: employees

Sample table: departments

Click me to see the solution

14. Write a SQL subquery to find the employee ID, first name, last name and salary of all employees whose salary is above the average salary for their departments.

Sample table: employees

Sample table: departments

Click me to see the solution

15. Write a subquery to find the 5th maximum salary of all salaries.

Sample table: employees

Click me to see the solution

16. Write a subquery to find the 4th minimum salary of all the salaries.

Sample table: employees

Click me to see the solution

17. Write a subquery to select last 10 records from a table.

Sample table: employees

Sample table: departments