How to use the where clause in sql?

Example:

-- Attempting to retrieve customers older than 20 without a WHERE clause
SELECT name FROM customers;

Solution:

-- Correctly retrieving customers older than 20 using the WHERE clause
SELECT name FROM customers WHERE age > 20;

The WHERE clause in SQL filters the results based on a condition. Here, we're filtering to only select customers who are older than 20 years.