Table: economy_alberta
Columns: rank_2012
rank_2010
employer
industry
2012_employees_total
2010_employees_total
2007_employees_total
head_office

Question: What is the 2012 Employees (Total) when the rank (2012) is 7?
SQL: SELECT "2012_employees_total" FROM economy_alberta WHERE "rank_2012" = 7

Question: What is the total number of 2012 Employees (Total) when 2007 Employees (Total) is 8,985, and rank (2010) is smaller than 9?
SQL: SELECT COUNT("2012_employees_total") FROM economy_alberta WHERE "2007_employees_total" = '8,985' AND "rank_2010" < 9

Question: What shows for 2010 Employees (Total) when the employer is University of Alberta?
SQL: SELECT SUM("2010_employees_total") FROM economy_alberta WHERE "employer" = 'university of alberta'