Table: counties_us_sc
Columns: county
year_founded
county_seat
2010_census_population
july_1_2012_population_estimate
area_sq_mi
land_area_sq_mi

Question: Which is the largest area in Greenville County, by square mile?
SQL: SELECT MAX("area_sq_mi") FROM counties_us_sc WHERE "county" = 'greenville county'

Question: Which is the total number in the 2010 Census in Oconee County where the area in square miles was less than 674?
SQL: SELECT SUM("2010_census_population") FROM counties_us_sc WHERE "county" = 'oconee county' AND "area_sq_mi" < 674

Question: What is the total number of areas by square mile where the founding year was 1785, the county seat was in Spartanburg, and the land area by square mile was more than 811?
SQL: SELECT SUM("area_sq_mi") FROM counties_us_sc WHERE "year_founded" = '1785' AND "county_seat" = 'spartanburg' AND "land_area_sq_mi" > 811