Tell me about high-level SQL topics you’ve worked with, including how you approach writing and validating queries.
For the practical portion, write a query that identifies qualifying sites for active studies and demonstrates how you would validate the result. Include only sites with at least two completed enrollment events.
Output
- One row per qualifying site, with
study_name, site_name, total_participants, latest_event_date, and study_site_rank.
- Include only active studies and qualifying sites, ordered by
study_name, then study_site_rank, then site_id.
