The 'xxxxx' is a "table-alias". You can see it at the bottom of the "[table-or-subquery][1]" syntax diagram shown below, right after the optional AS keyword. ![table-or-subquery](/images/syntax/table-or-subquery.gif) [1]: https://www.sqlite.org/syntax/table-or-subquery.html