Edition Catalogue Report
Problem
Table: `edition`
| Column Name | Type |
|---|---|
| edition_id | int |
| book_id | int |
| release_year | int |
| copies | int |
| list_price | int |
Table: `book`
| Column Name | Type |
|---|---|
| book_id | int |
| title | varchar |
For every row in `edition`, report the book `title`, the `release_year`, and the `list_price`. Return the result in any order.
Tables
Example rows — the live problem includes the full dataset.
edition
| edition_id | book_id | release_year | copies | list_price |
|---|---|---|---|---|
| 1 | 100 | 2008 | 10 | 45 |
| 2 | 100 | 2009 | 12 | 45 |
| 7 | 200 | 2011 | 15 | 80 |
book
| book_id | title |
|---|---|
| 100 | Tidewater |
| 200 | Northwind |
| 300 | Saltmarsh |
Expected output
Your answer should return 3 rows with the columns title, release_year, list_price.
Starter code (SQL)
SELECT *
FROM edition;Solve this SQL question free
Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.
Solution & explanation
Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.
Sign up free to unlock