Minimum Donation Tier That Fits Each Venue

Problem

Table: `venues`

| Column Name | Type |
|---|---|
| venue_id | int |
| seats | int |

`venue_id` is the primary key. `seats` is how many attendees the venue can hold.

Table: `tiers`

| Column Name | Type |
|---|---|
| donation | int |
| attendees | int |

`donation` is the primary key. Each row means: at this donation level, `attendees` people are expected to attend.

For each venue, find the smallest `donation` tier whose expected `attendees` does not exceed the venue's `seats` (so the crowd fits). Return `venue_id` and that minimum donation in a column named `min_donation`. If no tier fits, return `-1` for that venue. Return the result in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns venue_id, min_donation.

Starter code (SQL)

SELECT *
FROM venues;

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