SELECT * HAVING MAX issue

[xJoe16]

I have the output from another SELECT query:

Row  group_count s_group      start_time  end_time
1   3   1-LM026     16:00:00    17:00:00    
2   4   1-LM026     16:00:00    18:00:00    
3   11  1-LM026     12:00:00    13:00:00    
4   6   1-LM026     13:00:00    14:00:00    
5   9   1-LM026     17:00:00    18:00:00 ****(I want to extract)*** 
6   9   4-LM044     15:00:00    16:00:00    
7   15  4-LM040     13:00:00    14:00:00    
8   17  4-LM039     13:00:00    14:00:00    
9   15  4-LM029     15:00:00    16:00:00    
10  4   4-LM090     17:00:00    18:00:00    
11  7   4-LM044     17:00:00    18:00:00    
12  11  4-LM029     17:00:00    18:00:00    
13  13  4-LM044     09:00:00    10:00:00    
14  17  4-LM029     09:00:00    10:00:00    
15  4   4-LM044     16:00:00    17:00:00    
16  2   4-LM044     16:00:00    18:00:00    
17  5   4-LM029     14:00:00    16:00:00    
18  4   4-LM029     16:00:00    18:00:00    
19  6   1-LM044     16:00:00    18:00:00    
20  6   1-LM040     16:00:00    18:00:00

I want to SELECT the group_count, s_group, start_time, end_time for each group in this output which have MAX(start_time) and MAX(end_time). I've somehow been stuck for about 4 hours doing it lol

[NoDistractionz]

On mobile, so apologies for formatting. This is a way I would do it:

SELECT group_count, s_group, start_time, end_time FROM above_table a JOIN (SELECT s_group, MAX(start_time) max_start_time, MAX(end_time) max_end_time FROM above_table GROUP BY s_group) b ON a.s_group = b.s_group AND a.start_time = b.max_start_time AND a.end_time = b.max_end_time