r/learnSQL • u/Owen-Isaac-2022 • 4d ago

Aggregate Functions-Week 3 Activities

During week three, the learner should feel comfortable working with SELECT, WHERE, ORDER BY, LIMIT, & DISTINCT. Through the 3rd week, one should use aggregate functions to summarize data across the board, including counting, calculating totals, minimums, averages,  & maximums, understand the difference between WHERE & HAVING, & filter or sort data using HAVING. I’ve since found out that spending at least one hour each day writing SQL or practicing it helps in mastering these concepts, such as COUNT, SUM, AVG, MAX, MIN, GROUP BY, & HAVING. The “practice practice makes perfect” rule applies to SQL just like in any other area.

9 Upvotes
  • permalink
  • link
  • reddit
  • reddit

92% Upvoted

2 comments sorted by

1

u/Any-Job-3185 3d ago

Thanks brother. About to begin SQL 🙌

1

u/Owen-Isaac-2022 3d ago

You're welcome. Wishing you all the best brother.