Grant Applicants Who Cleared Review

Problem

Table: `applicants`

| Column Name | Type |
|---|---|
| applicant_id | int |
| panel_id | int |
| tenure_years | int |

`applicant_id` is the primary key. `panel_id` is the review panel assigned to the applicant. `tenure_years` is how many years the applicant has worked in the field.

Table: `reviews`

| Column Name | Type |
|---|---|
| panel_id | int |
| points | int |

There is no unique single column. A panel scores several criteria, so a `panel_id` may appear in multiple rows, each row giving the points for one criterion. Return the `applicant_id` of every applicant who has at least `3` years of tenure and whose combined review points across their panel sum to more than `20`. Return the result in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns applicant_id.

Starter code (SQL)

SELECT *
FROM applicants;

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