A bar chart for what are the number of the name of rooms booked by customers whose first name has 'ROY' in part?, sort by the the number of roomname in ascending please.
CREATE TABLE Rooms (
    RoomId TEXT,
    roomName TEXT,
    beds INTEGER,
    bedType TEXT,
    maxOccupancy INTEGER,
    basePrice INTEGER,
    decor TEXT
)

CREATE TABLE Reservations (
    Code INTEGER,
    Room TEXT,
    CheckIn TEXT,
    CheckOut TEXT,
    Rate REAL,
    LastName TEXT,
    FirstName TEXT,
    Adults INTEGER,
    Kids INTEGER
)
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)
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: A bar chart for what are the number of the name of rooms booked by customers whose first name has 'ROY' in part?, sort by the the number of roomname in ascending please. ### Input: CREATE TABLE Rooms (
    RoomId TEXT,
    roomName TEXT,
    beds INTEGER,
    bedType TEXT,
    maxOccupancy INTEGER,
    basePrice INTEGER,
    decor TEXT
)

CREATE TABLE Reservations (
    Code INTEGER,
    Room TEXT,
    CheckIn TEXT,
    CheckOut TEXT,
    Rate REAL,
    LastName TEXT,
    FirstName TEXT,
    Adults INTEGER,
    Kids INTEGER
) ### 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)