13 Advanced Query Techniques
Sometimes data analysis requires advanced SQL techniques that go beyond a table join or basic SELECT query. In this chapter, we’ll cover techniques that include writing a query that uses the results of other queries as inputs and reclassifying numerical values into categories before counting them.
For the exercises, I’ll introduce a dataset of temperatures recorded in select US cities, and we’ll revisit datasets you’ve created in previous chapters. The code for the exercises is available, along with all the book’s resources, at https://nostarch.com/practical-sql-2nd-edition/. You’ll continue to use the analysis ...
Get Practical SQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
