Selecting data from specific columns
Select the data from the columns series_id
, release_date
, and title
. At the same time, rename title
to series_title
and cast the type of release_date
from Uint32
to Date
.
Note
We assume that you already created tables in step Creating a table and populated them with data in step Adding data to a table.
SELECT
series_id, -- The names of columns (series_id, release_date, title)
-- are separated by commas.
title AS series_title, -- You can use AS to rename columns
-- or give a name to an arbitrary expression
CAST(release_date AS Date) AS release_date
FROM series;
COMMIT;