DB Quacks SQL Tutorial · Chapter 6
The SELECT-List Wizard of Oz
Wizard duck appears with a starry hat and wand. Behold! I have massive tables with 100 columns but only want specific ones! Sometimes exclude columns, sometimes rename them. Master flexible column wizardry!
Your task
Select all columns from the ducks table except the 'id' column, and rename 'species' to 'duck_type'. You will be manipulating the column selection and names.
Hint
Look for ways to exclude specific columns and rename others in your SELECT statement.
Expected result
A table showing all columns except id, with species renamed to duck_type.
Tables
duck_diaries (10 rows)
| column | type |
|---|---|
diary_id | BIGINT |
duck_id | BIGINT |
entry_date | DATE |
diary_text | VARCHAR |
mood | VARCHAR |
duck_surveys (5000 rows)
| column | type |
|---|---|
survey_id | BIGINT |
duck_id | BIGINT |
age | BIGINT |
favorite_food | VARCHAR |
favorite_pond | BIGINT |
swimming_rating | BIGINT |
migration_preference | VARCHAR |
social_behavior | VARCHAR |
health_status | VARCHAR |
activity_level | VARCHAR |
survey_date | DATE |
survey_location | BIGINT |
ducks (15 rows)
| column | type |
|---|---|
id | BIGINT |
name | VARCHAR |
age | BIGINT |
species | VARCHAR |
birth_date | DATE |
arrival_date | DATE |
ponds (3 rows)
| column | type |
|---|---|
pond_id | BIGINT |
pond_name | VARCHAR |
location_lat | DOUBLE |
location_lng | DOUBLE |
capacity | BIGINT |
features | VARCHAR[] |
amenities | VARCHAR[] |
Database: https://dbquacks.com/data/databases/tutorial.duckdb
This page as markdown: https://dbquacks.com/tutorial/30.md