Each Author's Home Library

Problem

A library network records which libraries each author has borrowing rights at.

```
Membership
+-------------+---------+
| Column | Type |
+-------------+---------+
| author_id | int |
| library_id | int |
| home_flag | varchar |
+-------------+---------+
(author_id, library_id) is the primary key.
home_flag is one of ('Y','N'). 'Y' marks the author's home library; 'N' means it is a secondary library.
```

Authors may hold memberships at several libraries. When an author belongs to more than one, exactly one row is flagged `'Y'` as the home library. When an author belongs to only one library, that single row is flagged `'N'` but it is still their home library.

Report each author together with their home `library_id`. In any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns author_id, library_id.

Starter code (SQL)

SELECT *
FROM Membership;

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