SELECT count(*) FROM classroom WHERE building != 'Lamberton'
Count the number of rooms that are not in the Lamberton building.
SELECT count ( * ) FROM classroom WHERE building ! = 'Lamberton '
select count ( * ) from classroom where building ! = value
Count the number of rooms that are not in the Lamberton building .