Coffee Cupping Leaderboard

Problem

At a coffee cupping event, each sample receives a quality grade in `points` with two decimals.

Table: `cupping_results`

| Column | Type |
|------------|--------------|
| sample_id | int |
| points | decimal(4,2) |

`sample_id` is the primary key.

Write a query that assigns each sample a competition placing in a column named `placing`, following these rules:
- More `points` place better (placing 1 is the best).
- Samples with equal `points` share the same placing.
- Placings are consecutive with no gaps: after a tie, the next placing is the next whole number.

Return `points` and `placing`, ordered by `points` descending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 6 rows with the columns points, placing.

Starter code (SQL)

SELECT *
FROM cupping_results;

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