我有一个表Orders（id_trip，id_order），表Trip（id_hotel，id_bus，id_type_of_trip）和表Hotel（id_hotel，name）。

我想在表Orders中获得最常入住的酒店的名称。

SELECT hotel.name from Orders
 JOIN Trip
 on Orders.id_trip = Trip.id_hotel
 JOIN hotel
 on trip.id_hotel = hotel.id_hotel
  FROM (SELECT hotel.name, rank() over (order by cnt desc) rnk
          FROM (SELECT hotel.name, count(*) cnt
                  FROM Orders
                 GROUP BY hotel.name))
 WHERE rnk = 1;