Business Analyst: What is a SQL WHERE clause?

1SELECT * FROM orders
2WHERE status = 'completed'
3AND amount > 100
4AND order_date BETWEEN '2024-01-01' AND '2024-12-31';
5
6SELECT * FROM customers
7WHERE name LIKE '%Smith%';
8
9SELECT * FROM products
10WHERE category IN ('Electronics', 'Books');