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