for clarification please....what results would you expect from this data set
create table TestData (ID int,TestDate date, Score int)
insert into testdata Values ('1','1-Jan-16','10')
insert into testdata Values ('1','5-Jan-16','15')
insert into testdata Values ('1','10-Jan-16','5')
-- added
insert into testdata Values ('2','5-Jan-16','10')
insert into testdata Values ('2','8-Jan-16','10')
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day