SELECT DISTINCT building FROM classroom WHERE capacity  >  50
Find the buildings which have rooms with capacity more than 50.
SELECT DISTINCT building FROM classroom WHERE capacity > 50
select distinct building from classroom where capacity > value
Find the buildings which have rooms with capacity more than 50 .