Middle-Tier Workshop Topics

Problem

Table: `Attendee`

```text
+----------+---------+
| Column | Type |
+----------+---------+
| person_id| int |
| fullname | varchar |
| topic | varchar |
+----------+---------+
person_id is the primary key. Each row says which workshop topic a person
signed up for. topic references a row in the Topic table.
```

Table: `Topic`

```text
+----------+---------+
| Column | Type |
+----------+---------+
| topic_id | int |
| topic | varchar |
+----------+---------+
topic_id is the primary key.
```

Find the workshop topics that are **neither the least popular nor the most popular** — that is, every topic whose sign-up count is **strictly greater than the smallest** topic's count **and strictly less than the largest** topic's count. Return the column `topic`. Rows may be in any order.

**Example**

```text
Attendee:
+-----------+----------+----------+
| person_id | fullname | topic |
+-----------+----------+----------+
| 1 | Ada | Welding |
| 2 | Bo | Welding |
| 3 | Cy | Welding |
| 4 | Di | Pottery |
| 5 | Ed | Pottery |
| 6 | Fi | Origami |
+-----------+----------+----------+

Output:
+----------+
| topic |
+----------+
| Pottery |
+----------+
```

Welding has 3 sign-ups (most), Origami has 1 (fewest), and Pottery has 2 — strictly between — so only Pottery is returned.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns topic.

Starter code (SQL)

SELECT *
FROM Attendee;

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