I would like to get an SQL Query which gives me an overview of closed Service Requests. This based on the tasks of that Service Request.
Several forums could not help :-(

My Table: ServiceRequestTasks

SRNr | TaskNr | TaskDescr | TaskCreationDate | InfoRecDate  

0001 | T00000 | Start\_\_\_\_\_ |1/01/2018  

0001 | T00001 | SD2C\_\_\_\_ | 2/01/2018\_\_\_\_\_\_\_| 4/01/2019  

0001 | T00002 | D\_\_\_\_\_\_\_\_ | 5/01/2019  

0001 | T00003 | RAI\_\_\_\_\_\_ | 6/01/2019\_\_\_\_\_\_\_| 12/01/2019  

0001 | T00004 | SCR\_\_\_\_\_ | 15/01/2019  

0001 | T00005 | RAI\_\_\_\_\_\_ | 16/01/2019\_\_\_\_\_\_| 22/01/2019  

0001 | T00006 | SCR\_\_\_\_\_ | 28/01/2019  

0001 | T00007 | End\_\_\_\_\_\_ | 28/01/2019  

0002 | T00008 | Start\_\_\_\_\_ | 9/01/2018  

0002 | T00009 | SCR\_\_\_\_\_ | 10/01/2018  

0002 | T00010 | SD2C\_\_\_\_ | 11/01/2018\_\_\_\_\_\_\_| 12/01/2019  

0002 | T00011 | SCR\_\_\_\_\_ | 13/01/2019  

0002 | T00012 | End\_\_\_\_\_\_ | 13/01/2018  

0003 | T00013 | Start\_\_\_\_\_ | 14/01/2018  

0003 | T00014 | SD2C\_\_\_\_ | 15/01/2018\_\_\_\_\_\_\_| 16/01/2018  

0004 | T00015 | Start\_\_\_\_\_ | 16/01/2018  

0004 | T00016 | SCR\_\_\_\_\_ | 17/01/2018  

0004 | T00017 | SCR\_\_\_\_\_ | 18/01/2018  

0004 | T00018 | SD2C\_\_\_\_ | 19/01/2018\_\_\_\_\_\_\_| 30/01/2019  

0004 | T00019 | RAI\_\_\_\_\_\_ | 1/02/2019\_\_\_\_\_\_\_\_| 2/02/2019  

0004 | T00020 | SCR\_\_\_\_\_ | 2/02/2019  

0004 | T00021 | End\_\_\_\_\_\_ | 7/02/2019 

TaskNr has unique Id

InfoRecDate only filled in when TaskDescr = (SD2C OR RAI) AND SR is closed (SR Contains Task description "End")

Expected Output:

* 1 Line per Closed SR -> SR contains a task with TaskDescr = "End"
* Latest InfoRecDate per closed SR
* SR Closed date (= TaskCreationDate of TaskDescr "End")

So something like this:  

SR Number | "Latest" InfoRecDate | End Date

1 | 22/01/2019 | 28/01/2019

2 | 12/01/2019 | 13/01/2018

4 | 02/02/2019 | 07/02/2019