Bar chart, group and count the decor of rooms that have a king bed.
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 decor, COUNT(decor) FROM Rooms WHERE bedType = 'King' GROUP BY decor ORDER BY basePrice
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: Bar chart, group and count the decor of rooms that have a king bed. ### 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 decor, COUNT(decor) FROM Rooms WHERE bedType = 'King' GROUP BY decor ORDER BY basePrice