SELECT count(*) FROM classroom WHERE building  =  'Lamberton'
Count the number of classrooms in Lamberton.
SELECT count ( * ) FROM classroom WHERE building = 'Lamberton '
select count ( * ) from classroom where building = value
Count the number of classrooms in Lamberton .