DB Quacks SQL Tutorial · Chapter 1
The Great Catalog Mystery
Duckbert swims up to a magical lily pad with a glowing data terminal. An old turtle with tiny glasses appears: Welcome to Pondville! Im Professor Shellbert, keeper of our village knowledge. He points to the dark screen. To join our duck community, you need to learn how we organize information. This terminal holds all our village data treasures - but first, discover what tables exist!
Your task
Find all the tables in this database. You will be working with the main database that contains our duck village data.
Hint
Look for a command that displays information about the database structure.
Expected result
A list of all tables in the database.
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/1.md