SELECT g.Name
     , b.roomNo
     , b.From
     , b.To
     FROM Booking b
     JOIN Guest g ON g.No = b.gNo
     WHERE b.hNo = 1 AND b.From <= '10-01'
         AND (b.To IS NULL OR b.To >= '10-01');

NAME      ROOMNO FROM  TOO
--------- ------ ----- -----
Bob            5 09-27 10-04
Joe            4 09-21 10-24
Frank          7 09-30
Peter          3 09-22 10-02

SELECT g.Name
     , b.roomNo
     , r.price   --<-- new
     , b.From
     , b.To
     FROM Booking b
     JOIN Guest g ON g.No = b.gNo
     JOIN Room r ON r.roomNo = b.roomNo   --<-- new
     WHERE b.hNo = 1 AND b.From <= '10-01'
         AND (b.To IS NULL OR b.To >= '10-01');

NAME      PRICE ROOMNO FROM  TOO
--------- ----- ------ ----- -----
Bob          55      5 09-27 10-04
Bob          60      5 09-27 10-04
Joe          55      4 09-21 10-24
Joe          60      4 09-21 10-24
Frank        90      7 09-30
Frank       100      7 09-30
Peter        55      3 09-22 10-02
Peter        60      3 09-22 10-02