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.