SCHEMA:
CREATE TABLE Rooms (beds INTEGER, bedtype VARCHAR)
USER:
How many king beds are there?

QUERY:
SELECT SUM(beds) FROM Rooms WHERE bedtype = 'King'