Second Most Expensive Book Price

Problem

A bookshop tracks the listed price of every title it sells.

Table: `catalog_titles`

| Column | Type |
|-------------|------|
| title_id | int |
| list_price | int |

`title_id` is the primary key. Each row is the listed price (in whole shekels) of one book in the catalog.

Write a query that returns the **second highest distinct** `list_price` in the catalog, aliased as `runner_up_price`. If there is no such second distinct price, the query must return `NULL`.

Example

With prices 40, 55 and 72, the second highest distinct price is 55.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns runner_up_price.

Starter code (SQL)

SELECT *
FROM catalog_titles;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium