Books Missing a Record

Problem

Table: `titles`

| Column Name | Type |
|---|---|
| book_id | int |
| title | varchar |

`book_id` is the unique key. Each row gives a book's title.

Table: `pricing`

| Column Name | Type |
|---|---|
| book_id | int |
| price | int |

`book_id` is the unique key. Each row gives a book's price.

A book has incomplete information when it is missing from one of the two tables: it has a title but no price, or a price but no title. Return the `book_id` of every book with incomplete information, ordered by `book_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns book_id.

Starter code (SQL)

SELECT *
FROM titles;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy