Volunteers With All Three Certifications

SQLEasyJunior level~15 min

Problem

A disaster-relief org tracks each volunteer's certifications in `Certs`. To lead a field team a volunteer must hold all three of **FirstAid**, **Logistics**, and **Radio**. Return the `volunteer_id` of every volunteer who holds all three (they may hold others too), ordered by `volunteer_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Certs

volunteer_id	cert
301	FirstAid
301	Logistics
301	Radio

Expected output

Your answer should return 2 rows with the columns volunteer_id.

Starter code (SQL)

SELECT *
FROM Certs;

Solve this SQL question free

Write SQL and run it instantly in your browser — even on your phone. No signup needed to try.

Solve it now → Create free account

Solution & explanation

Create a free account to unlock the optimal solution, a step-by-step explanation, and the hidden test cases that grade your answer.