MySQL Subqueries Examples

Write a Subquery in WHERE Clause

Write a query to find all products priced higher than the average price of all products.

Expected output: List of products with price greater than average price.

Hint: Use a subquery in the WHERE clause to calculate the average price.

Use Subquery in SELECT Clause

Write a query to list customers with the total number of orders they have placed using a subquery in SELECT.

Expected output: Customer names with their order counts.

Hint: Use a subquery to count orders per customer.

Subquery in FROM Clause Practice

Write a query to find departments with average employee salary above 50000 using a subquery in FROM.

Expected output: Departments where average salary exceeds 50000.

Hint: Calculate average salary per department in the subquery.

A subquery is a query nested inside another SQL query that provides data to the outer query.

Subqueries can be used in SELECT, WHERE, and FROM clauses.

JOINs are preferred when retrieving related data from multiple tables for better performance and readability.