Hackathon Favorite With the Most Weighted Picks

Problem

Table: `nominations`

| Column Name | Type |
|---|---|
| judge | varchar |
| project | varchar |

Each row records that a judge nominated a project as a favorite. A judge gets one total vote: if a judge nominates several projects, that vote is split equally among them (nominating 2 projects gives each 0.5). A `project` of NULL means the judge abstained and contributes nothing.

Find the project(s) with the highest total weighted score. Return `project`, ordered by `project`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns project.

Starter code (SQL)

SELECT *
FROM nominations;

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