Use JOIN with multiple WHERE conditions and OR logic
I need to audit our provider roster. Pull every provider with their name, specialty, department name, hire date, and active status. Flag anyone who's inactive OR has a hire date after today — those are credentialing issues I need to resolve before the CMS review.
Each hint you reveal reduces the XP you can earn. Try the query first.
Providers and department names live in two different tables — connect them on `department_id`
A straightforward join, no WHERE filter. The 'red flags' are for Dr. Nguyen to spot by eye in the full roster
`SELECT p.first_name, p.last_name, p.specialty, d.department_name, p.hire_date, p.is_active FROM dim_providers p JOIN dim_departments d ON ___`