Select h.hNo, h.hName, h.city 
From Hotel as h
Inner Join Room as r
inner join Room as r2
on h.hNo = r.hNo and r.hNo=r2.hNo and r.rNo != r2.rNo and r.price > 1000 and r2.price > 1000;
