220
edits
Changes
Jump to navigation
Jump to search
→Cleaning geo table
San Francisco | Undisclosed Company | 2016 | 2
San Francisco | Undisclosed Company | 2015 | 3
Modify geo1 table query to get rid of Undisclosed Companies:
DROP TABLE geo1;
CREATE TABLE geo1 AS
SELECT DISTINCT *
FROM geo
WHERE coname NOT LIKE '%Undisc%';
--43631
SELECT *, COUNT(*)
FROM (SELECT city, coname, startyear FROM geo1)a
GROUP BY city, coname, startyear
HAVING COUNT(*) > 1;
--3
==Name Based Matching geo keys to companybase keys==
