In this exercise, we can make a “mini” dataset like so,
SELECT '2017-01-01' AS 'month' UNION SELECT '2017-02-01' AS 'month'
Does this actually create a new table in the database?
No, this method of making a “mini” dataset will not actually create a new table. Instead, it’s a way to easily create a temporary table, that will disappear after the program runs, without having to actually create one.
In order to create a table, you would need to use the
CREATE TABLE statement.