What's the Difference Between the WHERE and HAVING Clauses in PostgreSQL?

PostgreSQL - Interview Questions

Another question that interviewers may use to gauge your knowledge of PostgreSQL is to ask you the difference between the WHERE and HAVING clauses.

The WHERE and HAVING clauses filter data and restrict unwanted data from appearing in your result set. The main difference between these filters is :

WHERE is applied at the record level.

HAVING is applied to sets of records.