SQL | Comparing WHERE & HAVING clause | Filter records with WHERE|Filter aggregated rows with HAVING 

​@dataprojecthub
In this video we compare WHERE and HAVING clause in SQL, and see when to use both clause.
This video can be split into three parts -
~implementing where clause
~implementing having clause
~using subquery and where clause to mock having clause
HAVING clause is used to apply a filter on the result of GROUP BY based on the specified condition (i.e.. when an aggregate function is involved).
WHERE clause is used to filter records. It is used to extract only those records that fulfill a specified condition in the WHERE clause.
"Thanks for watching. If you liked this video, make sure to subscribe for more!”
#dataprojecthub
#data_project_hub