SELECT count(*) FROM Rooms WHERE bedType  =  "King";
How many rooms have a king bed?
SELECT count ( * ) FROM Rooms WHERE bedType = `` King '' ;
select count ( * ) from rooms where bedtype = value
How many rooms have a king bed ?