Part II

Now that we have some dirty data and a few keywords, we can start to write some more interesting queries. In the process, we’ll learn a few of the idiosyncrasies of SQL.

• Getting started
• Nothing can come of nothing: Using IS NULL
• Knowing your limitations: Using LIMIT
• Casting a wider net with LIKE
• Using string functions: SUBSTR(), TRIM(), UPPER(), LOWER()
• Pull yourself together: The concatenate operator (||)
• Pick One: Using BETWEEN and IN (NOT IN)
• Aggregate Functions: COUNT, MAX, MIN, SUM, AVG
• Beyond functions: Custom calculations
• Subqueries, the Russian dolls of SQL
• GROUP BY
• HAVING
• Revisiting subqueries
• Conclusion

A Gentle Introduction to SQL Using SQLite by Troy Thibodeaux is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.