Members Who Booked Yoga and Spin but Not Boxing

Problem

A fitness studio records every class a member books. The studio wants the members who have booked both the `Yoga` class and the `Spin` class but have never booked the `Boxing` class.

Table: `members`

| Column | Type |
|-------------|---------|
| member_id | int |
| member_name | varchar |

`member_id` is the primary key.

Table: `bookings`

| Column | Type |
|-------------|---------|
| booking_id | int |
| member_id | int |
| class_name | varchar |

`booking_id` is the primary key. Each row is one class booking by a member.

Write a query that returns the `member_id` and `member_name` of every member who has booked `Yoga` and `Spin` but has not booked `Boxing`. Return the rows ordered by `member_id`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns member_id, member_name.

Starter code (SQL)

SELECT *
FROM members;

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