sql server - Querying the Data with Min and Max of 2 attributes -

i have sql server datatable table: problems

here structure

     name   problem     date          iscurrent      -----------------------------------------      john   fever       22-06-2015        1      davis  high bp     20-06-2015        0      john   headache    25-05-2105        0      john   fever       20-05-2015        1      davis  high bp     10-05-2015        1 

i want query table 1 name @ time. e.g. if query problem john.

my result set should be

1. fever    20-05-2015 (min date of problem)   1 (iscurrent status of latest date) 2. headache 25-05-2015                             0 

for davis result set be

1. high bp   10-05-2015 (min date of problem) 0 (iscurrent status of latest date) 

since both min date , max date required here, optimized query?

select name, problem, min([date]) mindate,max(date) maxdate #t1  problemtable   group name, problem  select name, problem,max(date) maxdate, iscurrent #t2  problemtable group name, problem, iscurrent  select t1.name,t1.problem, t1.mindate, t2.iscurrent #t1 t1 inner join t2 t2 on t1.name=t2.name , t1.problem=t2.problem , t1.maxdate=t2.maxdate