Database: college_2
Question: How many rooms in each building have a capacity of over 50?
SQL:
SELECT count(*) ,  building FROM classroom WHERE capacity  >  50 GROUP BY building