AnalystPath

Well-Attended Fitness Sessions

SQLEasyJunior level~15 min

Problem

A gym logs one row each time a member signs up for a session.

```
SessionSignup
+-----------+---------+
| Column | Type |
+-----------+---------+
| member | varchar |
| session | varchar |
+-----------+---------+
(member, session) is the primary key; a member signs up for any session at most once.
```

Return the name of every `session` that has at least **5** members signed up. Return the result in any order.

Tables

Example rows — the live problem includes the full dataset.

SessionSignup
membersession
MiaSpin
NoahYoga
LiamSpin

Expected output

Your answer should return 1 row with the columns session.

Starter code (SQL)

SELECT *
FROM SessionSignup;

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

Related SQL questions