select RESER_PK, ROOM_NUM as ROOM, RES_DATE, BEGIN_TIME ;
from RR_RESER ;
where RESER_PK in ;
(select top 1 RESER_PK from RR_RESER alias RRR_2 ;
 where RRR_2.ROOM_NUM == ROOM ;
 AND RRR_2.RES_DATE = DATE() order by RRR_2.BEGIN_TIME descending);
 order by ROOM