WHERE

Rows filter করে।

SELECT *
FROM orders
WHERE amount > 1000;

Multiple:

SELECT *
FROM orders
WHERE
    amount > 1000
    AND city = 'Dhaka';

Important Difference

WHERE

aggregation-এর আগে filter।

HAVING

aggregation-এর পরে filter।

এই difference interview-এ খুব common।