instruction: A bar chart for what are the number of the name of rooms booked by customers whose first name has 'ROY' in part?, could you display from high to low by the names?
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 roomName DESC