Find the number of rooms for each bed type Visualize by bar chart, and show in ascending by the bars.
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 bedType, COUNT(*) FROM Rooms GROUP BY bedType ORDER BY bedType
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: Find the number of rooms for each bed type Visualize by bar chart, and show in ascending by the bars. ### 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 bedType, COUNT(*) FROM Rooms GROUP BY bedType ORDER BY bedType