Database: school_finance
Question: Count the number of budgets in year 2001 or before whose budgeted amount is greater than 3000
SQL:
SELECT count(*) FROM budget WHERE budgeted  >  3000 AND YEAR  <=  2001