Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)

Channel Avatar
Comment
X
Share
Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)
Basic Aggregate Functions in SQL (COUNT, SUM, AVG, MAX, and MIN)
Learn how to use SQL’s basic aggregation functions like COUNT, SUM, AVG, MAX, and MIN in this step-by-step tutorial!

Advanced SQL Aggregation Tutorial: https://youtu.be/nNrgRVIzeHg

Queries:
1) Get a count of all the rows: SELECT COUNT(*) FROM table
2) Get a SUM of a column in all the rows: SELECT SUM(column1) FROM table
3) Get the maxium number in a column: SELECT MAX(column1) FROM table
4) Get the minimum number in a column: SELECT MIN(column1) FROM table
5) You can also do arithmatic with these aggregate functions: SELECT MAX(column1)-MIN(column1) AS range FROM table
6) Or, like this: SELECT AVG(column1*column2) FROM table

Get the Northwind Database: https://www.youtube.com/watch?vnbIicI7K6Kk

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

Take the opportunity to connect and share this video with your friends and family if you find it useful.

Keywords: becoming a data scientist, becomingads.com, data science, data scientist, sql aggregation, sql count, sql sum, sql max, sql min, postgresql aggregation, aggregate functions

Read Also

Leave a Reply

Your email address will not be published. Required fields are marked *