You want to combine the results of two SELECT statements into a single result set, including all rows, even if they are duplicates.

Select match

Question $4$

$2$

You need to retrieve records from two tables where a certain condition holds true for both tables.

Select match

Question $4$

$3$

You want to retrieve records from one table that are not present in another table, eliminating the matching rows.

SUBQUERY

Question $4$

$4$

You want to find employees who have a salary greater than the average salary of all employees in the "Employees" table.

Select match

Question $4$

$5$

You're tasked with displaying all the employees from the "Employees" table along with their corresponding departments from the "Departments" table, even if there is no match in the "Departments" table.