cte

Combining CTEs and VALUES in SQLite

Here's how to use SQLite's syntax with a CTE to create a temporary table that you can then perform joins against in a query: Try that here.