Advanced Aggregate Functions in SQL (GROUP BY, HAVING vs. WHERE)

In this step-by-step video tutorial, you will learn some more advanced SQL aggregation concepts by using the GROUP BY, HAVING, and WHERE clauses! Learn about the BASIC aggregation Functions: https://youtu.be/jcoJuc5e3RE Queries: 1) Pull aggregate information with the GROUP BY clause: SELECT column1, column2, COUNT(column3) FROM table GROUP BY column1, column2 2) Use the HAVING clause to filter your aggregation: SELECT column1, COUNT(column2) FROM table GROUP BY column1 HAVING COUNT(column2) = 5 3) Use WHERE and HAVING clauses in the same query: SELECT column1, COUNT(column2) FROM table WHERE column1 = 3 GROUP BY column1 HAVING COUNT(column2) = 5 Get the Northwind Database: https://www.youtube.com/watch?v=nbIicI7K6Kk Support the Channel: 1) Subscribe: https://www.becomingads.com/o/youtube 2) DataCamp: https://www.becomingads.com/o/datacamp 3) Udacity: https://www.becomingads.com/o/udacity