Question

Display room details according to its rates in ascending order

Answer 1

-->Display room details according to its rates in ascending order. sql>select desc,rate from room orderd by desc asc; Find the names of guest who has allocated room for more than 3 days. sql>select gname from guest,room where guest.