CREATE TABLE reservations (code DECIMAL, room TEXT, checkin TEXT, checkout TEXT, rate DECIMAL, lastname TEXT, firstname TEXT, adults DECIMAL, kids DECIMAL)
CREATE TABLE rooms (roomid TEXT, roomname TEXT, beds DECIMAL, bedtype TEXT, maxoccupancy DECIMAL, baseprice DECIMAL, decor TEXT)

Find the number of rooms with price higher than 120 for different decor.
SELECT decor, COUNT(*) FROM rooms WHERE baseprice > 120 GROUP BY decor
SELECT "decor", COUNT(*) FROM "rooms" WHERE "baseprice" > 120 GROUP BY "decor"