Member Count per Club

Problem

Table: `Member`

```text
+-----------+---------+
| Column | Type |
+-----------+---------+
| member_id | int |
| member_name| varchar|
| year_level| varchar |
| club_id | int |
+-----------+---------+
member_id is the primary key.
```

Table: `Club`

```text
+---------+---------+
| Column | Type |
+---------+---------+
| club_id | int |
| club_name| varchar|
+---------+---------+
club_id is the primary key.
```

For **every** club in the Club table (including clubs that currently have no members), report the `club_name` and the number of members who belong to it as `member_count`. Sort by `member_count` descending, then by `club_name` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns club_name, member_count.

Starter code (SQL)

SELECT *
FROM Member;

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