What is the difference between having and where clause? code example

Example: difference between where and having clause

The difference between the having and
where clause in SQL is that the where
clause cannot be used with aggregates(max, min,count,avg,sum)
, but the having clause can.