Group and Summarize Results - Essential SQL Challenge – Interactive Tutorial | Essential SQL

In today’s lesson we’ll learn to summarize a query’s results by counting and summing or averaging a column’s values.
Specifically, you’ll learn how to:
• Group data into summary rows.
• Compute summary data by counting rows.
• Compute summary data by summing or averaging values.

The GROUP BY Tutorial is a good way to get some practice. Better yet why not follow along, while watching the video?

Not that you’ve completed the tutorial, how about learning more? If you’re willing to dig deeper, may I suggest reading What is the Difference between ORDER and GROUP BY?
Now I said this was a five-day challenge, but how about we pull all of this together in a bonus training? Are you up for it? If so, then look for my email tomorrow. There I’ll show you how you can combine results from more than one table.
I’m looking forward to showing you how in tomorrow’s bonus lesson.

#sqltutorial #sql #essentialsql

Resources & Links
______________________________