select 
T1.LINE_ID LINE
,min(T1.SEAT_F) SEAT_F
,MAX(T1.SEAT_T) SEAT_T
from SEAT_RESERVE T1
LEFT JOIN 
(
select
*
, row_number() over (partition by subT1.LINE_ID order by subT1.SEAT_NO asc) gyoNo
from SEAT_RESERVE subT1
) gyoT
left join 
(
select 
subT2.LINE_ID, min(subT2.SEAT_NO) startNo
from
SEAT_RESERVE subT2
) statrT
group by T1.LINE_ID,min(statrT.SEAT_F) ,MAX(subT1.SEAT_T) 
order by T1.LINE_ID desc , min(statrT.SEAT_F) asc
;