Practice SQL WHERE Clause Interview Questions

Write and run the SQL query in the interactive editor above to check your answer.

Write and run the SQL query in the interactive editor above to check your answer.

Write and run the SQL query in the interactive editor above to check your answer.

Write and run the SQL query in the interactive editor above to check your answer.

The WHERE clause filters rows returned by a query. Only rows where the condition evaluates to TRUE are included in the result.

Syntax

SELECT column1, column2
FROM table_name
WHERE condition;

You can combine conditions using AND, OR, and NOT.

SELECT order_id, status, total_amount
FROM orders
WHERE status = 'delivered'
  AND total_amount > 1000
ORDER BY total_amount DESC;

Find all delivered orders

Write a query to fetch all orders where the status is delivered.

SOLUTION

SELECT * FROM orders WHERE status = 'delivered'

Find products with stock below 30

Retrieve product_id, name, and stock for all products where stock is less than 30.

SOLUTION

SELECT product_id, name, stock FROM products WHERE stock < 30

Find customers from the USA

Fetch first_name, last_name, and city of all customers from the USA.

SOLUTION

SELECT first_name, last_name, city FROM customers WHERE country = 'USA'

Find high-value cancelled orders

Retrieve order_id, customer_id, and total_amount for all cancelled orders with a total above 500.

SOLUTION

SELECT order_id, customer_id, total_amount FROM orders WHERE status = 'cancelled' AND total_amount > 500