On 2015-07-31 02:40 PM, Simon Slavin wrote: > > I am noting an overlap with the things SQLite users have been using > sub-SELECTs for.
Quite, with the added advantage that you can reference the same CTE multiple times in later parts of the query, plus have two or more different aggregations on it in two or more different follow-up CTE's or later in the query - something not at all possible with a sub-select.
