American Institutes for Research needs to identify potentially duplicated assessment submissions before QA validation and reporting. Treat submissions as duplicates when the same participant completed the same assessment on the same administration date.
Write a PostgreSQL query that returns every submission belonging to a duplicate group.
Requirements
- Group submissions by
participant_id, assessment_id, and administration_date.
- Keep only groups containing more than one submission.
- Return participant and assessment details, the duplicate count, and each affected submission ID, ordered consistently for review.
