Now that we have a table of months, we will join it to the subscriptions table. This will result in a table containing every combination of month and subscription.
Ultimately, this table will be used to determine the status of each subscription in each month.
The workspace contains the
months temporary table from the previous exercise.
cross_join temporary table that is a
CROSS JOIN of
SELECT * FROM cross_join LIMIT 100;
at the bottom of this exercise so you can visualize the temporary table you create.
SELECT all the columns from the temporary table.