Understanding WHERE Clause

What You Will Learn

• Use AND / OR with parentheses to avoid logic mistakes.
• Use IN and BETWEEN for cleaner condition syntax.
• Avoid wrapping indexed columns in functions inside WHERE when possible.

Sample SQL

SELECT order_id, customer_id, total_amount
FROM orders
WHERE status = 'paid'
  AND total_amount >= 100
  AND created_at >= '2026-01-01';

Next Step

Try rewriting this query in your own schema, then use our tools to format and refine it.