Easy
Select values without a table II
Create the following table, without using any existing tables:
EXPECTED OUTPUT
+-----------+---------------+-------------+
| book | author | copies_sold |
+-----------+---------------+-------------+
| Moneyball | Michael Lewis | 1700000 |
+-----------+---------------+-------------+
If you were to write:
SELECT
'Matt' AS name,
'Data Scientist' AS job_title,
21 AS age
you'd produce a table like this:
+------+----------------+-----+
| name | job_title | age |
+------+----------------+-----+
| Matt | Data Scientist | 21 |
+------+----------------+-----+
SELECT
'Moneyball' AS book,
'Michael Lewis' AS author,
1700000 AS copies_sold