Mid-Chain Mentors

Problem

A company runs a mentorship program where one person mentors another.

```
Mentorship
+--------+---------+
| Column | Type |
+--------+---------+
| mentor | varchar |
| mentee | varchar |
+--------+---------+
(mentor, mentee) is the primary key. Each row means `mentor` mentors `mentee`.
```

A **mid-chain mentor** is a person who mentors at least one mentee AND is themselves mentored by someone (their name appears in the `mentee` column too).

Return each mid-chain mentor as `mentor`, along with the number of distinct people they mentor as `mentee_count`. Order the result by `mentor`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns mentor, mentee_count.

Starter code (SQL)

SELECT *
FROM Mentorship;

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