instruction: Find the number of the name of rooms booked by some customers whose first name contains ROY, and I want to sort by the the number of roomname in desc please.
response: SELECT roomName, COUNT(roomName) FROM Reservations AS T1 JOIN Rooms AS T2 ON T1.Room = T2.RoomId WHERE FirstName LIKE '%ROY%' GROUP BY roomName ORDER BY COUNT(roomName) DESC