email_status.sql

mysql> select distinct city,count(*) as counter from yelp where website is not null and email_scraper_status=0 group by city order by counter desc limit 20;
+--------------+---------+
| city         | counter |
+--------------+---------+
| new york     |    2851 |
| austin       |    1723 |
| seattle      |    1542 |
| los angeles  |    1377 |
| dallas       |    1376 |
| san jose     |    1186 |
| brooklyn     |     953 |
| sacramento   |     684 |
| fort worth   |     567 |
| manhattan    |     426 |
| NULL         |     322 |
| arlington    |     257 |
| plano        |     220 |
| bellevue     |     204 |
| fremont      |     163 |
| roseville    |     160 |
| santa monica |     157 |
| cambridge    |     141 |
| irving       |     134 |
| santa clara  |     133 |
+--------------+---------+
20 rows in set (0.66 sec)