Changes

VC Database Rebuild (view source)

307 bytes added , 13:14, 24 July 2017

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==

220

edits