What location of school name Bremen?
select location from school where school_name = "Bremen"
How many enrollment of school id 2?
select enrollment from school where school_id = "2"
How many invested in the school with mascot Falcons?
select invested from school as t1 join budget as t2 on t1.school_id = t2.school_id where t1.mascot = "Falcons"
List the name, IHSAA Football Class, and Mascot of the schools that have more than 6000 of budgeted amount or were founded before 2003, in the order of percent of total invested budget and total budgeted budget.
select t1.school_name, t1.mascot, t1.ihsaa_football_class from school as t1 join budget as t2 on t1.school_id = t2.school_id where budgeted > 6000 or year < 2003 order by t2.total_budget_percent_invested, t2.total_budget_percent_budgeted