Duplicate Locations

Identify and remove duplicate locations. Here are two methods:

select name, city, count(*) from locations group by 1,2 having count(*) >1;

select street, state, count(*) from locations group by 1,2 having count(*) >1;

select lat, zip, count(*) from locations group by 1,2 having count(*) >1;