SELECT count(*) FROM classroom WHERE building != 'Lamberton'
How many classrooms are not in Lamberton?
SELECT count ( * ) FROM classroom WHERE building ! = 'Lamberton '
select count ( * ) from classroom where building ! = value
How many classrooms are not in Lamberton ?