I have Provided the DB Backup and Screenshots to make life easier.
Steps required in Order with Screenshot
1. Total Row Count of ReportableResults is 309,290
2. Take DISTINCT of TestPRepetitionId Now the Row Count will be 100,886
3.. For this DISTINCT of TestPRepetitionId Take the Highest Version in Version Column
4. Based on DISTINCT of [TestPRepetitionId] and Highest Version in [Version ] Column get [ReportableResultId] & [AggregateResultId]
End of the Day Row Count will 100,886