Promotion-Track Baristas

Problem

A coffee chain runs a weekly customer-vote and records the top three baristas each week.

```
WeeklyVote
+-------------+------+
| Column | Type |
+-------------+------+
| week_no | int |
| top_pick | int |
| second_pick | int |
| third_pick | int |
+-------------+------+
week_no is the primary key. Each column holds the barista_id placed in that rank that week.

Barista
+-------------+---------+
| Column | Type |
+-------------+---------+
| barista_id | int |
| email | varchar |
| name | varchar |
+-------------+---------+
barista_id is the primary key.
```

A barista is on the **promotion track** if EITHER:
- they placed in the top three (any rank) in **three or more consecutive weeks**, OR
- they were the `top_pick` in **three or more** different weeks.

Report the `name` and `email` of every promotion-track barista, in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns name, email.

Starter code (SQL)

SELECT *
FROM WeeklyVote;

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