Schema: CREATE TABLE classroom (building VARCHAR, capacity VARCHAR)
Question: How many rooms whose capacity is less than 50 does the Lamberton building have?
SQL: SELECT COUNT(*) FROM classroom WHERE building = 'Lamberton' AND capacity < 50