Debut Harvest of Each Wine

Problem

Table: `vintage`

| Column Name | Type |
|---|---|
| vintage_id | int |
| wine_id | int |
| harvest_year | int |
| bottles | int |
| price | int |

`(vintage_id, harvest_year)` is the primary key. Each row records one bottling of a wine in a given year; a wine may have several rows in the same year.

For each `wine_id`, find the earliest `harvest_year` it appears in the table and return every row from that debut year. Output the columns `wine_id`, `first_year`, `bottles`, and `price`. Return the result in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns wine_id, first_year, bottles, price.

Starter code (SQL)

SELECT *
FROM vintage;

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