Currently learning Data Science, here is what I've learnt so far. Pt.3
Hey there! I'm getting used to posting here and really enjoying using this space to post my notes while learning. This time I learned about aggregates and how to structure my SQL queries when using them. Feel free to comment any tips, corrections, or suggestions you might have for me. Thx! ;) Aggregates - Calculations performed on multiple rows of a table. COUNT() - count the number of rows SUM()…
This post from a Dev.to contributor delves into the topic of aggregates in SQL, explaining how calculations are performed on multiple rows of a table. The author covers various aggregate functions, such as COUNT(), SUM(), MAX(), MIN(), and AVG(), as well as the ROUND() function for rounding values. They also discuss the use of conditionals within aggregates and how to apply WHERE and HAVING clauses to filter results based on individual rows or aggregate properties, respectively.
The post concludes with an introduction to the GROUP BY clause, which is used to group data based on an aggregate function and can be combined with ORDER BY and HAVING clauses for further data manipulation.
Brief written by urgent.news from Dev.to's own syndicated text. Machine-written — may contain errors; check the original before relying on it.
This story
This is one outlet's version. Read the fullest account.
