Fully Certified Staff

Problem

A company tracks training in three tables: staff(staff_id, full_name, team), modules(module_id, title, hours, team), and attempts(staff_id, module_id, term, result). Every team has a set of required modules (the modules whose team matches the staff member's team). Find every staff member who has a passing attempt (result = 'Pass') in every required module for their team. A person counts only if they passed all of their team's modules with no module left unattempted or failed. Order the result by staff_id.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 2 rows with the columns staff_id.

Starter code (SQL)

SELECT *
FROM staff;

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