Head First SQL, 2nd Edition

Chapter 6. Advanced Select Sorting and Aggregating

A Note for Early Release Readers

With Early Release ebooks, you get books in their earliest form—the author’s raw and unedited content as they write—so you can take advantage of these technologies long before the official release of these titles.

This will be the 6th chapter of the final book. Please note that the GitHub repo will be made active later on.

If you have comments about how we might improve the content and/or examples in this book, or if you notice missing material within this chapter, please reach out to the editor at [e-mail].

It’s time to take your SELECT to new heights. You already know how to SELECT data and use WHERE clauses. But sometimes your queries need a little more altitude than what SELECT and WHERE can achieve alone.

In this chapter, you’ll learn how to sort your data in multiple ways. You’ll build data groups and perform mathematical calculations on your results. And in CASE you need new categories, you’ll learn how to pull the rip cord with if-then-else logic for your own classifications. Make the SELECT jump and here we go!

Shopping around

Since the last chapter ended, your pal Josh has been busy, very busy.

Brain Power

Can you think of a strategy to help Josh view his data in ...