What is the average budget?
select avg(budgeted) from budget
How many budgets are above 2000?
select count(*) from budget where budgeted > 2000
How about the number of budgets that are above 3000?
select count(*) from budget where budgeted > 3000
Which of them are in year 2001 or before?
select count(*) from budget where budgeted > 3000 and year <= 2001