Easy

Select values without a table I

Create the following table, without using any existing tables:

EXPECTED OUTPUT
+---------+---------+
| country | capital |
+---------+---------+
| France  | Paris   |
+---------+---------+

If you were to write:

SELECT
  'Matt' AS name,
  'Data Scientist' AS job_title

you'd produce a table like this:

+------+----------------+
| name | job_title      |
+------+----------------+
| Matt | Data Scientist |
+------+----------------+

SELECT 'France' AS country, 'Paris' AS capital

  • This field is required.