Festival Category Wins

Problem

A film festival hands out four awards each year. Each award column stores the `director_id` of the winner.

```
Director
+-------------+---------+
| Column | Type |
+-------------+---------+
| director_id | int |
| director | varchar |
+-------------+---------+
director_id is the primary key.

AwardYear
+-------------+------+
| Column | Type |
+-------------+------+
| edition | int |
| best_picture | int |
| best_drama | int |
| best_comedy | int |
| best_short | int |
+-------------+------+
edition is the primary key. Each award column holds the director_id who won that award that edition.
```

Report how many festival awards each director has won. Exclude directors who never won anything.

Return `director_id`, `director`, and `total_wins`, in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns director_id, director, total_wins.

Starter code (SQL)

SELECT *
FROM Director;

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