select s1.LINE_ID as LINE,
s3.SEAT_NO as SEAT_F,
s1.SEAT_NO as SEAT_T
from SEAT_RESERVE s1
inner join SEAT_RESERVE s2
on s1.LINE_ID = s2.LINE_ID
and s1.SEAT_NO = s2.SEAT_NO +1
inner join SEAT_RESERVE s3
on s2.LINE_ID = s3.LINE_ID
and s2.SEAT_NO = s3.SEAT_NO +1
where s1.RSV_STATUS = '0'
and s2.RSV_STATUS = '0'
and s3.RSV_STATUS = '0'
order by s1.LINE_ID desc,
SEAT_F asc