mysql> select concat(latitude,",",longitude) as LATLONG, city, state, sum(case when gender between 1 and 2 then 1 else 0 end) as PAID_DELETES, sum(case when gender=1 then 1 else 0 end) as FEMALE, sum(case when gender=2 then 1 else 0 end) as MALE, sum(case when gender=1 then 1 else 0 end)/sum(case when gender between 1 and 2 then 1 else 0 end) as RATIO from us_am_am_member where first_name='' group by LATLONG order by FEMALE desc limit 100; +-----------------------+------------------+-------+--------------+--------+------+--------+ | LATLONG | city | state | PAID_DELETES | FEMALE | MALE | RATIO | +-----------------------+------------------+-------+--------------+--------+------+--------+ | 30.055815,-95.169196 | Kingwood | 45 | 42 | 18 | 24 | 0.4286 | | 34.096629,-118.412426 | Beverly Hills | 5 | 93 | 15 | 78 | 0.1613 | | 40.777277,-73.982489 | New York | 33 | 112 | 15 | 97 | 0.1339 | | 42.347026,-71.074793 | Boston | 22 | 95 | 14 | 81 | 0.1474 | | 40.768479,-73.960718 | New York | 33 | 99 | 14 | 85 | 0.1414 | | 40.779563,-73.949559 | New York | 33 | 71 | 13 | 58 | 0.1831 | | 34.122744,-84.296757 | Alpharetta | 11 | 88 | 13 | 75 | 0.1477 | | 40.745154,-73.980751 | New York | 33 | 99 | 11 | 88 | 0.1111 | | 33.153776,-96.848685 | Plano | 45 | 93 | 11 | 82 | 0.1183 | | 38.479575,-122.750548 | Santa Rosa | 5 | 24 | 11 | 13 | 0.4583 | | 40.756416,-73.970295 | New York | 33 | 127 | 11 | 116 | 0.0866 | | 38.906639,-77.016577 | Washington | 9 | 95 | 11 | 84 | 0.1158 | | 32.953968,-97.150453 | Southlake | 45 | 65 | 10 | 55 | 0.1538 | | 33.553217,-84.213596 | Stockbridge | 11 | 20 | 10 | 10 | 0.5000 | | 40.720024,-74.003648 | New York | 33 | 71 | 10 | 61 | 0.1408 | | 40.751186,-73.972138 | New York | 33 | 83 | 10 | 73 | 0.1205 | | 34.029562,-84.240658 | Atlanta | 11 | 89 | 10 | 79 | 0.1124 | | 41.035494,-73.628183 | Greenwich | 7 | 62 | 9 | 53 | 0.1452 | | 40.778345,-73.955085 | New York | 33 | 49 | 9 | 40 | 0.1837 | | 33.082934,-96.752101 | Plano | 45 | 31 | 9 | 22 | 0.2903 | | 29.718966,-95.421416 | Troy | 23 | 51 | 9 | 42 | 0.1765 | | 41.030604,-73.76394 | Westchester | 33 | 40 | 9 | 31 | 0.2250 | | 40.786538,-73.978644 | Albany | 33 | 69 | 9 | 60 | 0.1304 | | 41.138856,-73.347965 | Westport | 7 | 67 | 9 | 58 | 0.1343 | | 32.902378,-96.789669 | Dallas | 45 | 36 | 9 | 27 | 0.2500 | | 40.057937,-75.081966 | Philadelphia | 39 | 15 | 8 | 7 | 0.5333 | | 32.866007,-96.784662 | Dallas | 45 | 44 | 8 | 36 | 0.1818 | | 37.707586,-85.861867 | Elizabethtown | 18 | 26 | 8 | 18 | 0.3077 | | 30.027227,-95.529294 | Spring | 45 | 61 | 8 | 53 | 0.1311 | | 40.75205,-73.994517 | new york | 33 | 107 | 8 | 99 | 0.0748 | | 40.695472,-73.992723 | Brooklyn | 33 | 72 | 8 | 64 | 0.1111 | | 37.782569,-122.436359 | San Francisco | 5 | 39 | 8 | 31 | 0.2051 | | 40.732373,-73.989477 | New York | 33 | 92 | 8 | 84 | 0.0870 | | 31.282943,-94.807267 | Lufkin | 45 | 8 | 8 | 0 | 1.0000 | | 27.758748,-82.721353 | Saint Petersburg | 10 | 17 | 8 | 9 | 0.4706 | | 40.755284,-73.992008 | New York | 33 | 44 | 8 | 36 | 0.1818 | | 34.078365,-118.486589 | Los Angeles | 5 | 50 | 8 | 42 | 0.1600 | | 38.912682,-77.071704 | Washington | 9 | 63 | 8 | 55 | 0.1270 | | 41.923621,-87.653367 | Chicago | 14 | 101 | 7 | 94 | 0.0693 | | 39.575499,-104.861971 | Englewood | 6 | 51 | 7 | 44 | 0.1373 | | 33.865889,-84.425245 | Atlanta | 11 | 27 | 7 | 20 | 0.2593 | | 34.044755,-118.75538 | Malibu | 5 | 38 | 7 | 31 | 0.1842 | | 35.992568,-115.119585 | Henderson | 29 | 29 | 7 | 22 | 0.2414 | | 41.079898,-73.480707 | Darien | 7 | 22 | 7 | 15 | 0.3182 | | 29.665238,-98.502296 | San Antonio | 45 | 46 | 7 | 39 | 0.1522 | | 40.747748,-74.03386 | Hoboken | 31 | 103 | 7 | 96 | 0.0680 | | 33.750591,-84.387699 | Atlanta | 11 | 46 | 7 | 39 | 0.1522 | | 40.385487,-74.172575 | Holmdel | 31 | 18 | 7 | 11 | 0.3889 | | 39.612706,-104.883398 | Denver | 6 | 39 | 7 | 32 | 0.1795 | | 38.887343,-77.098842 | Arlington | 49 | 89 | 7 | 82 | 0.0787 | | 38.917847,-77.035346 | Washington | 9 | 60 | 7 | 53 | 0.1167 | | 33.665392,-117.968576 | Huntington Beach | 5 | 30 | 7 | 23 | 0.2333 | | 41.168961,-73.26513 | New Canaan | 7 | 38 | 7 | 31 | 0.1842 | | 33.788039,-84.385689 | Atlanta | 11 | 48 | 7 | 41 | 0.1458 | | 37.448337,-122.268736 | Redwood City | 5 | 17 | 7 | 10 | 0.4118 | | 33.032072,-96.802811 | Plano | 45 | 56 | 7 | 49 | 0.1250 | | 33.629473,-117.868392 | San Diego | 5 | 82 | 7 | 75 | 0.0854 | | 32.458921,-83.730638 | Perry | 11 | 10 | 7 | 3 | 0.7000 | | 33.403565,-86.711683 | Birmingham | 1 | 69 | 7 | 62 | 0.1014 | | 40.395074,-74.109292 | Middletown | 31 | 20 | 7 | 13 | 0.3500 | | 40.666364,-73.985457 | Brooklyn | 33 | 50 | 7 | 43 | 0.1400 | | 39.428406,-76.769758 | Owings Mills | 21 | 31 | 6 | 25 | 0.1935 | | 29.754852,-95.415733 | Houston | 45 | 32 | 6 | 26 | 0.1875 | | 40.724608,-73.980332 | New York | 33 | 33 | 6 | 27 | 0.1818 | | 40.803692,-73.402157 | Melville | 33 | 32 | 6 | 26 | 0.1875 | | 33.651823,-112.167339 | glendale | 3 | 37 | 6 | 31 | 0.1622 | | 39.660246,-104.779822 | Aurora | 6 | 33 | 6 | 27 | 0.1818 | | 32.966396,-96.798494 | Dallas | 45 | 33 | 6 | 27 | 0.1818 | | 33.67842,-111.806618 | Scottsdale | 3 | 87 | 6 | 81 | 0.0690 | | 41.894244,-87.622841 | Chicago | 14 | 81 | 6 | 75 | 0.0741 | | 40.628781,-74.094599 | Staten Island | 33 | 18 | 6 | 12 | 0.3333 | | 40.36746,-74.66952 | Princeton | 31 | 63 | 6 | 57 | 0.0952 | | 33.436148,-117.623087 | San Clemente | 5 | 28 | 6 | 22 | 0.2143 | | 39.441925,-74.512041 | Absecon | 31 | 8 | 6 | 2 | 0.7500 | | 33.599601,-111.889956 | Scottsdale | 3 | 67 | 6 | 61 | 0.0896 | | 41.085715,-73.541654 | Stamford | 7 | 20 | 6 | 14 | 0.3000 | | 40.790284,-73.946781 | New York | 33 | 27 | 6 | 21 | 0.2222 | | 40.764248,-73.987442 | New York | 33 | 91 | 6 | 85 | 0.0659 | | 33.97986,-81.26052 | Lexington | 42 | 28 | 6 | 22 | 0.2143 | | 47.61133,-122.333219 | Seattle | 50 | 80 | 6 | 74 | 0.0750 | | 25.665235,-80.301146 | Miami | 10 | 23 | 6 | 17 | 0.2609 | | 28.538375,-81.374693 | Orlando | 10 | 43 | 6 | 37 | 0.1395 | | 28.114509,-82.363889 | Tampa | 10 | 31 | 6 | 25 | 0.1935 | | 37.786816,-122.39558 | San Francisco | 5 | 39 | 6 | 33 | 0.1538 | | 44.984777,-93.270181 | minneapolis | 24 | 70 | 6 | 64 | 0.0857 | | 32.934024,-97.250604 | Keller | 45 | 47 | 6 | 41 | 0.1277 | | 40.724324,-73.996124 | New York | 33 | 60 | 6 | 54 | 0.1000 | | 36.023482,-115.150519 | Las Vegas | 29 | 23 | 6 | 17 | 0.2609 | | 39.964218,-75.200972 | phila | 39 | 62 | 6 | 56 | 0.0968 | | 30.21162,-97.85184 | Austin | 45 | 24 | 6 | 18 | 0.2500 | | 45.499027,-122.688364 | Portland | 38 | 18 | 6 | 12 | 0.3333 | | 40.65846,-111.881914 | Salt Lake City | 46 | 27 | 6 | 21 | 0.2222 | | 41.944335,-87.702859 | Chicago | 14 | 48 | 6 | 42 | 0.1250 | | 42.208818,-71.000729 | Braintree | 22 | 16 | 6 | 10 | 0.3750 | | 42.315117,-71.43412 | Framingham | 22 | 31 | 6 | 25 | 0.1935 | | 42.194268,-88.135521 | Barrington | 14 | 49 | 6 | 43 | 0.1224 | | 44.353599,-69.731361 | Augusta | 20 | 10 | 6 | 4 | 0.6000 | | 30.319171,-97.93746 | Austin | 45 | 23 | 5 | 18 | 0.2174 | | 41.898992,-87.636455 | Chicago | 14 | 53 | 5 | 48 | 0.0943 | | 40.569297,-111.967229 | South Jordan | 46 | 43 | 5 | 38 | 0.1163 | +-----------------------+------------------+-------+--------------+--------+------+--------+ 100 rows in set (16.37 sec) mysql> select concat(latitude,",",longitude) as LATLONG, city, state, sum(case when gender between 1 and 2 then 1 else 0 end) as PAID_DELETES, sum(case when gender=1 then 1 else 0 end) as FEMALE, sum(case when gender=2 then 1 else 0 end) as MALE, sum(case when gender=1 then 1 else 0 end)/sum(case when gender between 1 and 2 then 1 else 0 end) as RATIO from us_am_am_member where first_name='' and dob between '1955-07-01' and '1985-07-01' group by LATLONG order by FEMALE desc limit 100; +-----------------------+------------------+-------+--------------+--------+------+--------+ | LATLONG | city | state | PAID_DELETES | FEMALE | MALE | RATIO | +-----------------------+------------------+-------+--------------+--------+------+--------+ | 30.055815,-95.169196 | Kingwood | 45 | 38 | 17 | 21 | 0.4474 | | 40.777277,-73.982489 | New York | 33 | 100 | 14 | 86 | 0.1400 | | 42.347026,-71.074793 | Boston | 22 | 86 | 13 | 73 | 0.1512 | | 34.122744,-84.296757 | Alpharetta | 11 | 81 | 13 | 68 | 0.1605 | | 34.096629,-118.412426 | Beverly Hills | 5 | 81 | 12 | 69 | 0.1481 | | 40.768479,-73.960718 | New York | 33 | 77 | 11 | 66 | 0.1429 | | 34.029562,-84.240658 | Carnesville | 11 | 78 | 10 | 68 | 0.1282 | | 33.553217,-84.213596 | Stockbridge | 11 | 20 | 10 | 10 | 0.5000 | | 33.153776,-96.848685 | Dallas | 45 | 86 | 10 | 76 | 0.1163 | | 38.906639,-77.016577 | Washington | 9 | 86 | 10 | 76 | 0.1163 | | 40.720024,-74.003648 | New York | 33 | 68 | 10 | 58 | 0.1471 | | 32.953968,-97.150453 | Southlake | 45 | 60 | 9 | 51 | 0.1500 | | 41.030604,-73.76394 | White Plains | 33 | 34 | 9 | 25 | 0.2647 | | 33.082934,-96.752101 | Plano | 45 | 31 | 9 | 22 | 0.2903 | | 40.756416,-73.970295 | New York | 33 | 111 | 9 | 102 | 0.0811 | | 40.778345,-73.955085 | New York | 33 | 44 | 9 | 35 | 0.2045 | | 40.751186,-73.972138 | New York | 33 | 68 | 8 | 60 | 0.1176 | | 32.866007,-96.784662 | Dallas | 45 | 42 | 8 | 34 | 0.1905 | | 31.282943,-94.807267 | Lufkin | 45 | 8 | 8 | 0 | 1.0000 | | 41.138856,-73.347965 | Fairfield | 7 | 57 | 8 | 49 | 0.1404 | | 40.745154,-73.980751 | New York | 33 | 80 | 8 | 72 | 0.1000 | | 40.057937,-75.081966 | Philadelphia | 39 | 12 | 8 | 4 | 0.6667 | | 40.695472,-73.992723 | Brooklyn | 33 | 64 | 8 | 56 | 0.1250 | | 29.718966,-95.421416 | Houston | 45 | 45 | 8 | 37 | 0.1778 | | 27.758748,-82.721353 | Saint Petersburg | 10 | 15 | 8 | 7 | 0.5333 | | 41.035494,-73.628183 | Greenwich | 7 | 50 | 8 | 42 | 0.1600 | | 37.707586,-85.861867 | Elizabethtown | 18 | 23 | 8 | 15 | 0.3478 | | 40.755284,-73.992008 | New York | 33 | 42 | 8 | 34 | 0.1905 | | 40.779563,-73.949559 | New York | 33 | 50 | 8 | 42 | 0.1600 | | 32.902378,-96.789669 | Dallas | 45 | 27 | 8 | 19 | 0.2963 | | 33.865889,-84.425245 | Atlanta | 11 | 22 | 7 | 15 | 0.3182 | | 33.665392,-117.968576 | Newport Beach | 5 | 27 | 7 | 20 | 0.2593 | | 33.403565,-86.711683 | Birmingham | 1 | 65 | 7 | 58 | 0.1077 | | 30.027227,-95.529294 | Spring | 45 | 53 | 7 | 46 | 0.1321 | | 34.078365,-118.486589 | Los Angeles | 5 | 41 | 7 | 34 | 0.1707 | | 41.079898,-73.480707 | Darien | 7 | 20 | 7 | 13 | 0.3500 | | 38.912682,-77.071704 | Washington | 9 | 57 | 7 | 50 | 0.1228 | | 29.665238,-98.502296 | San Antonio | 45 | 41 | 7 | 34 | 0.1707 | | 35.992568,-115.119585 | Henderson | 29 | 24 | 7 | 17 | 0.2917 | | 37.782569,-122.436359 | San Francisco | 5 | 38 | 7 | 31 | 0.1842 | | 41.168961,-73.26513 | Fairfield | 7 | 35 | 7 | 28 | 0.2000 | | 39.612706,-104.883398 | Englewood | 6 | 27 | 7 | 20 | 0.2593 | | 33.032072,-96.802811 | Plano | 45 | 54 | 7 | 47 | 0.1296 | | 33.629473,-117.868392 | Newport Beach | 5 | 74 | 7 | 67 | 0.0946 | | 41.923621,-87.653367 | Chicago | 14 | 85 | 7 | 78 | 0.0824 | | 39.575499,-104.861971 | Englewood | 6 | 49 | 7 | 42 | 0.1429 | | 33.788039,-84.385689 | Atlanta | 11 | 44 | 7 | 37 | 0.1591 | | 38.887343,-77.098842 | Arlington | 49 | 77 | 7 | 70 | 0.0909 | | 40.395074,-74.109292 | Middletown | 31 | 19 | 7 | 12 | 0.3684 | | 37.448337,-122.268736 | Redwood City | 5 | 17 | 7 | 10 | 0.4118 | | 40.385487,-74.172575 | Holmdel | 31 | 16 | 7 | 9 | 0.4375 | | 34.044755,-118.75538 | Malibu | 5 | 33 | 7 | 26 | 0.2121 | | 40.666364,-73.985457 | Brooklyn | 33 | 48 | 7 | 41 | 0.1458 | | 33.651823,-112.167339 | Glendale | 3 | 35 | 6 | 29 | 0.1714 | | 37.786816,-122.39558 | San Francisco | 5 | 37 | 6 | 31 | 0.1622 | | 42.208818,-71.000729 | Braintree | 22 | 15 | 6 | 9 | 0.4000 | | 40.732373,-73.989477 | New York | 33 | 74 | 6 | 68 | 0.0811 | | 40.803692,-73.402157 | Melville | 33 | 29 | 6 | 23 | 0.2069 | | 40.724608,-73.980332 | New York | 33 | 27 | 6 | 21 | 0.2222 | | 41.085715,-73.541654 | Stamford | 7 | 16 | 6 | 10 | 0.3750 | | 44.984777,-93.270181 | Clearwater | 24 | 65 | 6 | 59 | 0.0923 | | 33.67842,-111.806618 | Scottsdale | 3 | 78 | 6 | 72 | 0.0769 | | 40.790284,-73.946781 | New York | 33 | 23 | 6 | 17 | 0.2609 | | 42.194268,-88.135521 | Barrington | 14 | 40 | 6 | 34 | 0.1500 | | 40.628781,-74.094599 | Staten Island | 33 | 15 | 6 | 9 | 0.4000 | | 39.964218,-75.200972 | Philadelphia | 39 | 55 | 6 | 49 | 0.1091 | | 25.665235,-80.301146 | Miami | 10 | 17 | 6 | 11 | 0.3529 | | 44.353599,-69.731361 | Augusta | 20 | 10 | 6 | 4 | 0.6000 | | 38.917847,-77.035346 | Washington | 9 | 51 | 6 | 45 | 0.1176 | | 41.944335,-87.702859 | Chicago | 14 | 45 | 6 | 39 | 0.1333 | | 33.436148,-117.623087 | Niota | 44 | 23 | 6 | 17 | 0.2609 | | 36.023482,-115.150519 | Las Vegas | 29 | 19 | 6 | 13 | 0.3158 | | 40.747748,-74.03386 | Hoboken | 31 | 89 | 6 | 83 | 0.0674 | | 33.750591,-84.387699 | Atlanta | 11 | 41 | 6 | 35 | 0.1463 | | 40.764248,-73.987442 | New York | 33 | 76 | 6 | 70 | 0.0789 | | 30.21162,-97.85184 | Austin | 45 | 22 | 6 | 16 | 0.2727 | | 32.934024,-97.250604 | Keller | 45 | 45 | 6 | 39 | 0.1333 | | 28.114509,-82.363889 | Tampa | 10 | 30 | 6 | 24 | 0.2000 | | 39.428406,-76.769758 | Baltimore | 21 | 24 | 6 | 18 | 0.2500 | | 42.315117,-71.43412 | Framingham | 22 | 29 | 6 | 23 | 0.2069 | | 40.75205,-73.994517 | New York | 33 | 91 | 6 | 85 | 0.0659 | | 33.97986,-81.26052 | Lexington | 42 | 26 | 6 | 20 | 0.2308 | | 39.660246,-104.779822 | Aurora | 6 | 25 | 6 | 19 | 0.2400 | | 45.499027,-122.688364 | Portland | 38 | 16 | 6 | 10 | 0.3750 | | 33.776725,-118.14615 | Long Beach | 5 | 11 | 5 | 6 | 0.4545 | | 40.309639,-74.18206 | Staten Island | 33 | 14 | 5 | 9 | 0.3571 | | 37.38739,-122.071863 | Mountain View | 5 | 13 | 5 | 8 | 0.3846 | | 40.243519,-74.277392 | Freehold | 31 | 42 | 5 | 37 | 0.1190 | | 47.61133,-122.333219 | Seattle | 50 | 70 | 5 | 65 | 0.0714 | | 25.784853,-80.144731 | Miami Beach | 10 | 32 | 5 | 27 | 0.1563 | | 33.145623,-97.090468 | Denton | 45 | 14 | 5 | 9 | 0.3571 | | 40.111368,-75.546198 | Phoenixville | 39 | 27 | 5 | 22 | 0.1852 | | 39.40409,-76.608279 | Towson | 21 | 22 | 5 | 17 | 0.2273 | | 41.151963,-73.496253 | New Canaan | 7 | 20 | 5 | 15 | 0.2500 | | 32.671991,-97.432311 | Fort Worth | 45 | 18 | 5 | 13 | 0.2778 | | 42.648787,-71.162026 | Andover | 22 | 36 | 5 | 31 | 0.1389 | | 40.569297,-111.967229 | South Jordan | 46 | 41 | 5 | 36 | 0.1220 | | 37.714234,-121.930817 | Dublin | 5 | 38 | 5 | 33 | 0.1316 | | 37.436934,-122.193602 | Menlo Park | 5 | 37 | 5 | 32 | 0.1351 | | 42.33696,-71.06376 | Boston | 22 | 26 | 5 | 21 | 0.1923 | +-----------------------+------------------+-------+--------------+--------+------+--------+ 100 rows in set (10 min 21.43 sec) mysql> select concat(round(latitude,2),",",round(longitude,2)) as LATLONG, city, state, sum(case when gender between 1 and 2 then 1 else 0 end) as PAID_DELETES, sum(case when gender=1 then 1 else 0 end) as FEMALE, sum(case when gender=2 then 1 else 0 end) as MALE, sum(case when gender=1 then 1 else 0 end)/sum(case when gender between 1 and 2 then 1 else 0 end) as RATIO from us_am_am_member where first_name='' group by LATLONG order by FEMALE desc limit 100; +---------------+------------------+-------+--------------+--------+------+--------+ | LATLONG | city | state | PAID_DELETES | FEMALE | MALE | RATIO | +---------------+------------------+-------+--------------+--------+------+--------+ | 40.76,-73.99 | New York | 33 | 218 | 19 | 199 | 0.0872 | | 30.06,-95.17 | Kingwood | 45 | 43 | 18 | 25 | 0.4186 | | 40.72,-74.00 | New York | 33 | 131 | 16 | 115 | 0.1221 | | 40.77,-73.96 | new york | 33 | 170 | 16 | 154 | 0.0941 | | 34.10,-118.41 | Beverly Hills | 5 | 97 | 15 | 82 | 0.1546 | | 40.78,-73.98 | New York | 33 | 119 | 15 | 104 | 0.1261 | | 40.78,-73.96 | New York | 33 | 78 | 14 | 64 | 0.1795 | | 42.35,-71.07 | Boston | 22 | 95 | 14 | 81 | 0.1474 | | 34.12,-84.30 | Alpharetta | 11 | 88 | 13 | 75 | 0.1477 | | 40.76,-73.97 | New York | 33 | 143 | 13 | 130 | 0.0909 | | 40.78,-73.95 | new york | 33 | 81 | 13 | 68 | 0.1605 | | 38.48,-122.75 | Santa Rosa | 5 | 24 | 11 | 13 | 0.4583 | | 33.15,-96.85 | Plano | 45 | 93 | 11 | 82 | 0.1183 | | 40.75,-73.98 | New York | 33 | 129 | 11 | 118 | 0.0853 | | 38.91,-77.02 | Washington | 9 | 97 | 11 | 86 | 0.1134 | | 40.75,-73.97 | New York | 33 | 93 | 10 | 83 | 0.1075 | | 34.03,-84.24 | Atlanta | 11 | 92 | 10 | 82 | 0.1087 | | 32.95,-97.15 | Southlake | 45 | 66 | 10 | 56 | 0.1515 | | 33.55,-84.21 | Stockbridge | 11 | 22 | 10 | 12 | 0.4545 | | 32.93,-97.25 | Keller | 45 | 89 | 10 | 79 | 0.1124 | | 41.04,-73.63 | Greenwich | 7 | 62 | 9 | 53 | 0.1452 | | 41.92,-87.65 | Chicago | 14 | 107 | 9 | 98 | 0.0841 | | 41.14,-73.35 | Westport | 7 | 67 | 9 | 58 | 0.1343 | | 32.90,-96.79 | Dallas | 45 | 38 | 9 | 29 | 0.2368 | | 41.03,-73.76 | Westchester | 33 | 40 | 9 | 31 | 0.2250 | | 40.79,-73.98 | Albany | 33 | 70 | 9 | 61 | 0.1286 | | 29.72,-95.42 | Troy | 23 | 53 | 9 | 44 | 0.1698 | | 33.08,-96.75 | Plano | 45 | 31 | 9 | 22 | 0.2903 | | 32.87,-96.78 | Dallas | 45 | 44 | 8 | 36 | 0.1818 | | 33.63,-117.87 | San Diego | 5 | 88 | 8 | 80 | 0.0909 | | 37.78,-122.44 | San Francisco | 5 | 39 | 8 | 31 | 0.2051 | | 38.91,-77.07 | Washington | 9 | 63 | 8 | 55 | 0.1270 | | 40.70,-73.99 | Brooklyn | 33 | 73 | 8 | 65 | 0.1096 | | 34.08,-118.49 | Los Angeles | 5 | 50 | 8 | 42 | 0.1600 | | 40.73,-73.99 | New York | 33 | 95 | 8 | 87 | 0.0842 | | 37.79,-122.40 | San Francisco | 5 | 69 | 8 | 61 | 0.1159 | | 40.06,-75.08 | Jenkintown | 39 | 17 | 8 | 9 | 0.4706 | | 27.76,-82.72 | Saint Petersburg | 10 | 17 | 8 | 9 | 0.4706 | | 37.71,-85.86 | Elizabethtown | 18 | 26 | 8 | 18 | 0.3077 | | 31.28,-94.81 | Lufkin | 45 | 8 | 8 | 0 | 1.0000 | | 45.50,-122.69 | Portland | 38 | 45 | 8 | 37 | 0.1778 | | 44.98,-93.27 | Minneapolis | 24 | 112 | 8 | 104 | 0.0714 | | 33.75,-84.39 | Atlanta | 11 | 50 | 8 | 42 | 0.1600 | | 30.03,-95.53 | Spring | 45 | 62 | 8 | 54 | 0.1290 | | 40.75,-73.99 | new york | 33 | 108 | 8 | 100 | 0.0741 | | 38.89,-77.10 | Arlington | 49 | 95 | 7 | 88 | 0.0737 | | 39.61,-104.88 | Denver | 6 | 39 | 7 | 32 | 0.1795 | | 40.75,-74.03 | Hoboken | 31 | 103 | 7 | 96 | 0.0680 | | 29.67,-98.50 | San Antonio | 45 | 46 | 7 | 39 | 0.1522 | | 34.04,-118.76 | Malibu | 5 | 38 | 7 | 31 | 0.1842 | | 40.67,-73.99 | Brooklyn | 33 | 50 | 7 | 43 | 0.1400 | | 33.67,-117.97 | Huntington Beach | 5 | 31 | 7 | 24 | 0.2258 | | 33.03,-96.80 | Plano | 45 | 56 | 7 | 49 | 0.1250 | | 29.75,-95.42 | Houston | 45 | 34 | 7 | 27 | 0.2059 | | 35.99,-115.12 | Henderson | 29 | 35 | 7 | 28 | 0.2000 | | 40.40,-74.11 | Middletown | 31 | 20 | 7 | 13 | 0.3500 | | 39.96,-75.20 | phila | 39 | 88 | 7 | 81 | 0.0795 | | 32.46,-83.73 | Perry | 11 | 10 | 7 | 3 | 0.7000 | | 41.08,-73.48 | Darien | 7 | 22 | 7 | 15 | 0.3182 | | 39.68,-104.89 | Denver | 6 | 34 | 7 | 27 | 0.2059 | | 41.17,-73.27 | New Canaan | 7 | 38 | 7 | 31 | 0.1842 | | 33.40,-86.71 | Birmingham | 1 | 69 | 7 | 62 | 0.1014 | | 33.79,-84.39 | Atlanta | 11 | 48 | 7 | 41 | 0.1458 | | 40.39,-74.17 | Holmdel | 31 | 18 | 7 | 11 | 0.3889 | | 33.87,-84.43 | Atlanta | 11 | 27 | 7 | 20 | 0.2593 | | 37.45,-122.27 | Redwood City | 5 | 17 | 7 | 10 | 0.4118 | | 38.92,-77.04 | Chicago | 14 | 67 | 7 | 60 | 0.1045 | | 39.58,-104.86 | Denver | 6 | 54 | 7 | 47 | 0.1296 | | 41.09,-73.54 | Ellsworth | 20 | 22 | 6 | 16 | 0.2727 | | 33.01,-96.89 | Carrollton | 45 | 26 | 6 | 20 | 0.2308 | | 28.54,-81.37 | Orlando | 10 | 46 | 6 | 40 | 0.1304 | | 32.97,-96.80 | Dallas | 45 | 35 | 6 | 29 | 0.1714 | | 40.71,-74.01 | NYC | 33 | 135 | 6 | 129 | 0.0444 | | 40.63,-74.09 | Staten Island | 33 | 20 | 6 | 14 | 0.3000 | | 42.32,-71.43 | Framingham | 22 | 31 | 6 | 25 | 0.1935 | | 42.23,-88.33 | Crystal Lake | 14 | 31 | 6 | 25 | 0.1935 | | 39.44,-74.51 | Absecon | 31 | 8 | 6 | 2 | 0.7500 | | 42.19,-88.14 | Barrington | 14 | 49 | 6 | 43 | 0.1224 | | 47.61,-122.33 | Seattle | 50 | 86 | 6 | 80 | 0.0698 | | 33.60,-111.89 | Scottsdale | 3 | 67 | 6 | 61 | 0.0896 | | 44.35,-69.73 | Augusta | 20 | 10 | 6 | 4 | 0.6000 | | 41.94,-87.70 | Chicago | 14 | 48 | 6 | 42 | 0.1250 | | 28.11,-82.36 | Tampa | 10 | 31 | 6 | 25 | 0.1935 | | 25.67,-80.30 | Miami | 10 | 23 | 6 | 17 | 0.2609 | | 33.98,-81.26 | Lexington | 42 | 29 | 6 | 23 | 0.2069 | | 40.37,-74.67 | Princeton | 31 | 63 | 6 | 57 | 0.0952 | | 33.68,-111.81 | Scottsdale | 3 | 87 | 6 | 81 | 0.0690 | | 40.80,-73.40 | Melville | 33 | 32 | 6 | 26 | 0.1875 | | 40.79,-73.95 | New York | 33 | 28 | 6 | 22 | 0.2143 | | 36.02,-115.15 | Las Vegas | 29 | 23 | 6 | 17 | 0.2609 | | 33.65,-112.17 | glendale | 3 | 37 | 6 | 31 | 0.1622 | | 38.96,-77.34 | Reston | 49 | 47 | 6 | 41 | 0.1277 | | 39.43,-76.77 | Owings Mills | 21 | 31 | 6 | 25 | 0.1935 | | 39.66,-104.78 | Aurora | 6 | 33 | 6 | 27 | 0.1818 | | 30.21,-97.85 | Austin | 45 | 24 | 6 | 18 | 0.2500 | | 42.21,-71.00 | Braintree | 22 | 16 | 6 | 10 | 0.3750 | | 33.44,-117.62 | San Clemente | 5 | 28 | 6 | 22 | 0.2143 | | 40.66,-111.88 | Salt Lake City | 46 | 29 | 6 | 23 | 0.2069 | | 41.89,-87.62 | Chicago | 14 | 85 | 6 | 79 | 0.0706 | | 40.72,-73.98 | New York | 33 | 34 | 6 | 28 | 0.1765 | +---------------+------------------+-------+--------------+--------+------+--------+ 100 rows in set (28.34 sec) mysql> select concat(round(latitude,1),",",round(longitude,1)) as LATLONG, city, state, sum(case when gender between 1 and 2 then 1 else 0 end) as PAID_DELETES, sum(case when gender=1 then 1 else 0 end) as FEMALE, sum(case when gender=2 then 1 else 0 end) as MALE, sum(case when gender=1 then 1 else 0 end)/sum(case when gender between 1 and 2 then 1 else 0 end) as RATIO from us_am_am_member where first_name='' group by LATLONG order by FEMALE desc limit 100; +-------------+------------------------+-------+--------------+--------+------+--------+ | LATLONG | city | state | PAID_DELETES | FEMALE | MALE | RATIO | +-------------+------------------------+-------+--------------+--------+------+--------+ | 40.8,-74.0 | New York | 33 | 1365 | 129 | 1236 | 0.0945 | | 40.7,-74.0 | New York | 33 | 1368 | 108 | 1260 | 0.0789 | | 42.3,-71.1 | Boston | 22 | 381 | 41 | 340 | 0.1076 | | 38.9,-77.1 | Arlington | 49 | 504 | 40 | 464 | 0.0794 | | 40.8,-73.9 | Astoria | 33 | 308 | 40 | 268 | 0.1299 | | 34.1,-118.4 | beverly hills | 5 | 435 | 38 | 397 | 0.0874 | | 38.9,-77.0 | Washington | 9 | 519 | 37 | 482 | 0.0713 | | 41.9,-87.6 | Chicago | 14 | 502 | 34 | 468 | 0.0677 | | 32.8,-96.8 | Dallas | 45 | 313 | 32 | 281 | 0.1022 | | 37.8,-122.4 | San Francisco | 5 | 437 | 30 | 407 | 0.0686 | | 33.8,-84.4 | Atlanta | 11 | 260 | 28 | 232 | 0.1077 | | 42.4,-71.1 | Boston | 22 | 502 | 26 | 476 | 0.0518 | | 32.9,-96.8 | Dallas | 45 | 154 | 25 | 129 | 0.1623 | | 34.0,-118.5 | Laurel | 21 | 297 | 25 | 272 | 0.0842 | | 41.9,-87.7 | Chicago | 14 | 406 | 24 | 382 | 0.0591 | | 29.7,-95.4 | Troy | 23 | 263 | 24 | 239 | 0.0913 | | 30.1,-95.2 | Kingwood | 45 | 88 | 23 | 65 | 0.2614 | | 33.0,-96.8 | Addison | 45 | 216 | 20 | 196 | 0.0926 | | 41.1,-73.5 | Stamford | 7 | 135 | 20 | 115 | 0.1481 | | 45.5,-122.7 | Portland | 38 | 164 | 20 | 144 | 0.1220 | | 34.0,-118.4 | Venice | 5 | 203 | 19 | 184 | 0.0936 | | 42.0,-87.7 | Saint Louis | 26 | 226 | 18 | 208 | 0.0796 | | 40.6,-74.0 | New Hyde Park | 33 | 192 | 18 | 174 | 0.0938 | | 34.1,-118.3 | los angelesLos Angeles | 5 | 237 | 18 | 219 | 0.0759 | | 33.8,-118.1 | seal beach | 5 | 117 | 18 | 99 | 0.1538 | | 39.0,-77.1 | Chevy Chase | 21 | 236 | 18 | 218 | 0.0763 | | 40.7,-73.9 | New York | 33 | 271 | 17 | 254 | 0.0627 | | 34.1,-118.2 | Los Angeles | 5 | 122 | 17 | 105 | 0.1393 | | 47.6,-122.3 | Seattle | 50 | 287 | 17 | 270 | 0.0592 | | 39.7,-105.0 | Denver | 6 | 308 | 16 | 292 | 0.0519 | | 37.4,-122.1 | Redwood City | 5 | 144 | 16 | 128 | 0.1111 | | 39.6,-104.9 | Denver | 6 | 115 | 16 | 99 | 0.1391 | | 33.6,-117.9 | Newport Beach | 5 | 201 | 16 | 185 | 0.0796 | | 29.8,-95.4 | Houston | 45 | 295 | 16 | 279 | 0.0542 | | 42.0,-87.8 | Park Ridge | 14 | 119 | 15 | 104 | 0.1261 | | 40.1,-75.1 | Jenkintown | 39 | 67 | 15 | 52 | 0.2239 | | 38.8,-77.1 | Alexandria | 49 | 334 | 15 | 319 | 0.0449 | | 37.3,-121.9 | San Jose | 5 | 192 | 15 | 177 | 0.0781 | | 40.7,-73.6 | East Meadow | 33 | 170 | 14 | 156 | 0.0824 | | 34.1,-84.3 | Alpharetta | 11 | 118 | 14 | 104 | 0.1186 | | 34.1,-118.1 | Pasadena | 5 | 105 | 14 | 91 | 0.1333 | | 33.1,-96.8 | plano | 45 | 91 | 14 | 77 | 0.1538 | | 34.2,-118.4 | Valley Village | 5 | 146 | 14 | 132 | 0.0959 | | 40.4,-74.1 | Middletown | 31 | 58 | 14 | 44 | 0.2414 | | 41.0,-73.8 | Columbia | 21 | 124 | 14 | 110 | 0.1129 | | 34.0,-84.2 | Atlanta | 11 | 155 | 14 | 141 | 0.0903 | | 33.2,-96.8 | Irving | 45 | 159 | 13 | 146 | 0.0818 | | 41.0,-73.6 | Greenwich | 7 | 101 | 13 | 88 | 0.1287 | | 26.0,-80.3 | Hollywood | 10 | 74 | 13 | 61 | 0.1757 | | 37.7,-121.9 | Chapel Hill | 34 | 130 | 13 | 117 | 0.1000 | | 42.2,-71.0 | Braintree | 22 | 65 | 13 | 52 | 0.2000 | | 33.0,-97.2 | DFW Area | 45 | 83 | 13 | 70 | 0.1566 | | 33.9,-84.3 | Atlanta | 11 | 144 | 12 | 132 | 0.0833 | | 40.0,-75.1 | Philadelphia | 39 | 119 | 12 | 107 | 0.1008 | | 40.0,-75.2 | Philadelphia | 39 | 222 | 12 | 210 | 0.0541 | | 37.8,-122.2 | Oakland | 5 | 98 | 12 | 86 | 0.1224 | | 40.7,-111.9 | Salt Lake City | 46 | 128 | 12 | 116 | 0.0938 | | 37.9,-122.1 | Pleasant Hill | 5 | 103 | 12 | 91 | 0.1165 | | 38.5,-122.8 | Santa Rosa | 5 | 43 | 12 | 31 | 0.2791 | | 40.7,-74.3 | Union | 31 | 189 | 12 | 177 | 0.0635 | | 33.5,-112.1 | Phoenix | 3 | 67 | 12 | 55 | 0.1791 | | 33.9,-84.4 | Atlanta | 11 | 164 | 12 | 152 | 0.0732 | | 45.0,-93.3 | Minneapolis | 24 | 181 | 12 | 169 | 0.0663 | | 38.6,-121.5 | Sacramento | 5 | 115 | 12 | 103 | 0.1043 | | 42.3,-71.4 | Natick | 22 | 84 | 11 | 73 | 0.1310 | | 29.8,-95.6 | Houston | 45 | 109 | 11 | 98 | 0.1009 | | 34.0,-84.4 | Marietta | 11 | 96 | 11 | 85 | 0.1146 | | 40.8,-73.8 | Bronx | 33 | 125 | 11 | 114 | 0.0880 | | 30.2,-97.8 | Austin | 45 | 114 | 11 | 103 | 0.0965 | | 33.8,-84.3 | atlanta | 11 | 122 | 11 | 111 | 0.0902 | | 41.8,-71.4 | Providence | 41 | 133 | 11 | 122 | 0.0827 | | 41.1,-73.3 | Westport | 7 | 73 | 11 | 62 | 0.1507 | | 40.8,-73.7 | New York | 33 | 70 | 11 | 59 | 0.1571 | | 40.8,-74.2 | Montclair | 31 | 160 | 11 | 149 | 0.0688 | | 39.7,-104.9 | Denver | 6 | 113 | 11 | 102 | 0.0973 | | 40.8,-111.9 | Salt Lake City | 46 | 121 | 10 | 111 | 0.0826 | | 33.5,-82.1 | Augusta | 11 | 85 | 10 | 75 | 0.1176 | | 29.7,-95.5 | Houston | 45 | 203 | 10 | 193 | 0.0493 | | 33.6,-84.2 | Lithonia | 11 | 21 | 10 | 11 | 0.4762 | | 40.7,-73.7 | Long Island City | 33 | 173 | 10 | 163 | 0.0578 | | 32.7,-117.2 | San Diego | 5 | 207 | 10 | 197 | 0.0483 | | 29.7,-98.5 | San Antonio | 45 | 68 | 10 | 58 | 0.1471 | | 35.8,-78.8 | Raleigh | 34 | 117 | 10 | 107 | 0.0855 | | 32.7,-117.1 | san diego | 5 | 60 | 10 | 50 | 0.1667 | | 40.7,-73.5 | Bellmore | 33 | 118 | 10 | 108 | 0.0847 | | 41.2,-73.2 | Easton | 7 | 64 | 10 | 54 | 0.1563 | | 47.7,-122.3 | Seattle | 50 | 171 | 10 | 161 | 0.0585 | | 39.2,-76.8 | Falls Church | 49 | 52 | 10 | 42 | 0.1923 | | 27.8,-82.7 | Saint Petersburg | 10 | 52 | 10 | 42 | 0.1923 | | 33.3,-111.9 | Chandler | 3 | 76 | 10 | 66 | 0.1316 | | 33.0,-96.7 | Plano | 45 | 125 | 10 | 115 | 0.0800 | | 34.1,-118.5 | Los Angeles | 5 | 124 | 10 | 114 | 0.0806 | | 40.6,-74.1 | staten island | 33 | 85 | 10 | 75 | 0.1176 | | 40.6,-74.3 | Toms River | 31 | 103 | 10 | 93 | 0.0971 | | 25.7,-80.4 | Miami | 10 | 114 | 10 | 104 | 0.0877 | | 32.7,-97.4 | Fort Worth | 45 | 87 | 10 | 77 | 0.1149 | | 37.4,-122.2 | Menlo Park | 5 | 85 | 10 | 75 | 0.1176 | | 37.3,-122.0 | santa clara | 5 | 135 | 9 | 126 | 0.0667 | | 39.4,-76.6 | baltimore | 21 | 92 | 9 | 83 | 0.0978 | | 35.8,-78.6 | Raleigh | 34 | 102 | 9 | 93 | 0.0882 | +-------------+------------------------+-------+--------------+--------+------+--------+ 100 rows in set (17.19 sec) mysql> select concat(round(latitude,0),",",round(longitude,0)) as LATLONG, city, state, sum(case when gender between 1 and 2 then 1 else 0 end) as PAID_DELETES, sum(case when gender=1 then 1 else 0 end) as FEMALE, sum(case when gender=2 then 1 else 0 end) as MALE, sum(case when gender=1 then 1 else 0 end)/sum(case when gender between 1 and 2 then 1 else 0 end) as RATIO from us_am_am_member where first_name='' group by LATLONG order by FEMALE desc limit 100; +---------+-----------------------+-------+--------------+--------+------+--------+ | LATLONG | city | state | PAID_DELETES | FEMALE | MALE | RATIO | +---------+-----------------------+-------+--------------+--------+------+--------+ | 41,-74 | New York | 33 | 7904 | 647 | 7257 | 0.0819 | | 34,-118 | Los Angeles | 5 | 4854 | 390 | 4464 | 0.0803 | | 39,-77 | Washington | 9 | 4828 | 333 | 4495 | 0.0690 | | 33,-97 | DFW Area | 45 | 3113 | 308 | 2805 | 0.0989 | | 42,-88 | Aurora | 14 | 3773 | 298 | 3475 | 0.0790 | | 40,-75 | Bryn Mawr | 39 | 2765 | 212 | 2553 | 0.0767 | | 42,-71 | South Easton | 22 | 2590 | 211 | 2379 | 0.0815 | | 34,-84 | Atlanta | 11 | 2098 | 189 | 1909 | 0.0901 | | 38,-122 | San Mateo | 5 | 2012 | 179 | 1833 | 0.0890 | | 41,-73 | Danbury | 7 | 1751 | 164 | 1587 | 0.0937 | | 26,-80 | Miami | 10 | 1786 | 154 | 1632 | 0.0862 | | 30,-95 | Houston | 45 | 1745 | 144 | 1601 | 0.0825 | | 40,-105 | Denver | 6 | 1915 | 138 | 1777 | 0.0721 | | 37,-122 | Monterey | 5 | 1086 | 110 | 976 | 0.1013 | | 30,-98 | Austin | 45 | 1191 | 102 | 1089 | 0.0856 | | 33,-117 | san diego | 5 | 1587 | 91 | 1496 | 0.0573 | | 40,-74 | Little Silver | 31 | 862 | 87 | 775 | 0.1009 | | 45,-93 | Eden Prairie | 24 | 1514 | 84 | 1430 | 0.0555 | | 30,-96 | Houston | 45 | 1238 | 76 | 1162 | 0.0614 | | 34,-119 | Westlake Village | 5 | 815 | 74 | 741 | 0.0908 | | 48,-122 | Seattle | 50 | 1394 | 74 | 1320 | 0.0531 | | 40,-76 | Chadds Ford | 39 | 1047 | 70 | 977 | 0.0669 | | 41,-112 | South Jordan | 46 | 913 | 66 | 847 | 0.0723 | | 36,-79 | Raleigh | 34 | 795 | 64 | 731 | 0.0805 | | 43,-71 | Burlington | 22 | 950 | 64 | 886 | 0.0674 | | 35,-81 | Charlotte | 34 | 1058 | 63 | 995 | 0.0595 | | 33,-112 | Mesa | 3 | 962 | 62 | 900 | 0.0644 | | 42,-73 | Glastonbury | 7 | 801 | 61 | 740 | 0.0762 | | 41,-82 | NE OH and WPA | 36 | 775 | 60 | 715 | 0.0774 | | 34,-112 | Scottsdale | 3 | 894 | 59 | 835 | 0.0660 | | 36,-115 | Henderson | 29 | 592 | 59 | 533 | 0.0997 | | 40,-86 | Anderson | 15 | 798 | 59 | 739 | 0.0739 | | 42,-72 | Central | 22 | 613 | 55 | 558 | 0.0897 | | 34,-117 | Murrieta | 5 | 616 | 55 | 561 | 0.0893 | | 41,-75 | Somerville | 31 | 772 | 55 | 717 | 0.0712 | | 43,-83 | Clarkston | 23 | 841 | 53 | 788 | 0.0630 | | 29,-81 | Orlando | 10 | 564 | 50 | 514 | 0.0887 | | 43,-88 | Milwaukee | 52 | 677 | 50 | 627 | 0.0739 | | 28,-83 | Tampa | 10 | 638 | 50 | 588 | 0.0784 | | 39,-121 | Folsom | 5 | 555 | 48 | 507 | 0.0865 | | 28,-82 | Kissimmee | 10 | 566 | 48 | 518 | 0.0848 | | 40,-83 | Upper Arlington | 36 | 739 | 47 | 692 | 0.0636 | | 39,-95 | Leavenworth | 17 | 845 | 45 | 800 | 0.0533 | | 40,-80 | Pittsburgh | 39 | 674 | 44 | 630 | 0.0653 | | 42,-83 | Detroit | 23 | 675 | 44 | 631 | 0.0652 | | 36,-87 | Dickson | 44 | 704 | 44 | 660 | 0.0625 | | 34,-85 | Acworth | 11 | 550 | 44 | 506 | 0.0800 | | 39,-78 | Martinsburg | 51 | 427 | 43 | 384 | 0.1007 | | 27,-80 | West Palm Beach | 10 | 528 | 43 | 485 | 0.0814 | | 45,-123 | Beaverton | 38 | 453 | 42 | 411 | 0.0927 | | 39,-105 | Parker | 6 | 497 | 37 | 460 | 0.0744 | | 38,-123 | San Anselmo | 5 | 294 | 36 | 258 | 0.1224 | | 47,-122 | Kent | 50 | 462 | 36 | 426 | 0.0779 | | 39,-90 | st. louis | 26 | 630 | 35 | 595 | 0.0556 | | 42,-84 | Toledo | 36 | 492 | 35 | 457 | 0.0711 | | 46,-123 | Kirkland | 50 | 492 | 33 | 459 | 0.0671 | | 30,-82 | Jacksonville | 10 | 429 | 33 | 396 | 0.0769 | | 38,-86 | Louisville | 18 | 453 | 33 | 420 | 0.0728 | | 37,-76 | Crescent | 11 | 710 | 32 | 678 | 0.0451 | | 43,-86 | Grand Rapids | 23 | 307 | 32 | 275 | 0.1042 | | 28,-81 | Melbourne | 10 | 301 | 31 | 270 | 0.1030 | | 43,-74 | Saratoga Springs | 33 | 488 | 31 | 457 | 0.0635 | | 40,-77 | York | 39 | 575 | 31 | 544 | 0.0539 | | 33,-87 | Alabaster | 1 | 293 | 28 | 265 | 0.0956 | | 41,-81 | Beachwood | 36 | 390 | 27 | 363 | 0.0692 | | 35,-107 | Rio Rancho | 32 | 319 | 26 | 293 | 0.0815 | | 30,-90 | Gretna | 19 | 433 | 26 | 407 | 0.0600 | | 31,-98 | Austin | 45 | 290 | 26 | 264 | 0.0897 | | 40,-84 | Miamisburg | 36 | 329 | 25 | 304 | 0.0760 | | 39,-85 | Cincinnati | 36 | 411 | 25 | 386 | 0.0608 | | 39,-84 | Alexandria | 18 | 511 | 24 | 487 | 0.0470 | | 42,-94 | Omaha | 28 | 300 | 24 | 276 | 0.0800 | | 30,-99 | San Antonio | 45 | 256 | 24 | 232 | 0.0938 | | 35,-90 | Memphis | 44 | 342 | 23 | 319 | 0.0673 | | 43,-76 | Syracuse | 33 | 267 | 23 | 244 | 0.0861 | | 43,-78 | Scottsville | 33 | 299 | 23 | 276 | 0.0769 | | 43,-72 | Peterborough NH | 30 | 284 | 23 | 261 | 0.0810 | | 34,-81 | Columbia | 42 | 248 | 22 | 226 | 0.0887 | | 36,-84 | Knoxville | 44 | 279 | 22 | 257 | 0.0789 | | 43,-79 | Buffalo | 33 | 438 | 22 | 416 | 0.0502 | | 32,-111 | Tucson | 3 | 361 | 22 | 339 | 0.0609 | | 39,-91 | Saint Louis | 26 | 280 | 22 | 258 | 0.0786 | | 43,-89 | Stoughton | 52 | 364 | 21 | 343 | 0.0577 | | 36,-80 | Winston Salem | 34 | 377 | 21 | 356 | 0.0557 | | 41,-96 | Omaha | 28 | 406 | 21 | 385 | 0.0517 | | 39,-76 | EASTERNSHORE | 21 | 276 | 21 | 255 | 0.0761 | | 42,-74 | lower Dutchess County | 33 | 270 | 21 | 249 | 0.0778 | | 38,-121 | Sacramento | 5 | 297 | 21 | 276 | 0.0707 | | 27,-82 | Charlotte | 34 | 311 | 21 | 290 | 0.0675 | | 37,-120 | Fresno | 5 | 200 | 21 | 179 | 0.1050 | | 35,-82 | Woodruff | 42 | 310 | 21 | 289 | 0.0677 | | 38,-77 | Pasadena | 21 | 362 | 20 | 342 | 0.0552 | | 47,-123 | Lacey | 50 | 272 | 20 | 252 | 0.0735 | | 35,-79 | Raeford | 34 | 341 | 19 | 322 | 0.0557 | | 36,-83 | Asheville | 34 | 159 | 19 | 140 | 0.1195 | | 41,-76 | Schuylkill Haven | 39 | 275 | 19 | 256 | 0.0691 | | 32,-90 | Jackson | 25 | 157 | 19 | 138 | 0.1210 | | 35,-85 | Chattanooga | 44 | 201 | 19 | 182 | 0.0945 | | 39,-94 | Lees Summit | 26 | 270 | 19 | 251 | 0.0704 | | 41,-80 | Pittsburgh | 39 | 364 | 18 | 346 | 0.0495 | +---------+-----------------------+-------+--------------+--------+------+--------+ 100 rows in set (17.70 sec)