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
What are the name of rooms booked by customers whose first name has 'ROY' in part, and count them by a bar chart, and could you rank by the x axis from high to low?
CREATE TABLE Reservations (
    Code INTEGER,
    Room TEXT,
    CheckIn TEXT,
    CheckOut TEXT,
    Rate REAL,
    LastName TEXT,
    FirstName TEXT,
    Adults INTEGER,
    Kids INTEGER
)

CREATE TABLE Rooms (
    RoomId TEXT,
    roomName TEXT,
    beds INTEGER,
    bedType TEXT,
    maxOccupancy INTEGER,
    basePrice INTEGER,
    decor TEXT
)