GSK's Veeva Vault CTMS reporting team needs a concise enrollment summary for Phase 3 clinical trials during 2025. Write a PostgreSQL query that combines trial, site, and enrollment data.
Requirements
- Use
INNER JOIN to connect trials, trial_sites, and enrollments.
- Include only Phase 3 enrollments recorded during calendar year 2025.
- Group results by trial and country, returning the number of distinct sites and total participants.
- Exclude groups with no positive enrollment, then sort by total participants descending, followed by trial name and country ascending.
ORDER BY is the PostgreSQL term for sorting query results.
