Intermediate

Two related tables

Create two tables (no constraints needed yet):

authors — author_id INTEGER, author_name VARCHAR, country VARCHAR
novels — novel_id INTEGER, title VARCHAR, author_id INTEGER, price DECIMAL(8,2)

This question starts with an empty database.

Hints(0/2)

Unlocks after you solve it or after 3 submissions

SQL (DuckDB)

Ctrl + Enter to runLog in to save progress and earn XP

Run your code to see the output here.