SQLite: select statements

SQLite: joins

order by

SQLite: analyze

limit clause to select only the first n records or to page the result set.

The SQLite shell command .mode column that allows to format a select result in tabular form.