Tricky~22min

The Department That Never Hires

Engineering has had 5 open roles for 8 months. 847 applications received. 2 interviews conducted. The roles are still open. The hiring manager says the pipeline is "active."

Tables you'll query

job_postingsapplicationsinterviewsemployees

What you'll learn

SubqueriesJOINsAggregations & GROUP BYNULL Handling
Investigate this case →