Table: sorsogon_municipalities
Columns: city_municipality
no_of_s_barangay
district
area_km
population_2010
income_class_2007
zip_code
mayor

Question: What are all the vicinity (km²) where profits magnificence (2007) is 2nd
SQL: SELECT "area_km" FROM sorsogon_municipalities WHERE "income_class_2007" = '2nd'

Question: What are all the profits elegance (2007) in which mayor is ma. Ester a. Hamor
SQL: SELECT "income_class_2007" FROM sorsogon_municipalities WHERE "mayor" = 'Ma. Ester A. Hamor'

Question: What is the total quantity of populace (2010) where location (km²) is 134.51
SQL: SELECT COUNT("population_2010") FROM sorsogon_municipalities WHERE "area_km" = '134.51'

Question: What are all the metropolis / municipality where mayor is helen c. De castro
SQL: SELECT "city_municipality" FROM sorsogon_municipalities WHERE "mayor" = 'Helen C. De Castro'