Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published run test

SELECT * FROM benn.oscar_nominees
Published College Football Players

SELECT COUNT(*) FROM benn.college_football_... ON l.full_school_name = p.full_school_name
Published test3

SELECT * FROM mode.crunchbase_dimension_companies
Published what

SELECT * FROM mode.crunchbase_dimension_people
Published Stanford - Acquisition Price

SELECT CASE WHEN a.education = 1 THEN TRUE EL...5,6 ) z ) a GROUP BY 1
Published Stanford - Company Exits

SELECT CASE WHEN education = 1 THEN TRUE ELSE...Y 1,2,3,4,5 ) a GROUP BY 1 LIMIT 100
Published Stanford - Round Size

SELECT CASE WHEN a.stanford = 1 THEN TRUE ELS... ) z ) a GROUP BY 1,2 LIMIT 100
Published Stanford - Funding rounds

SELECT a.founded_year, COUNT(CASE WHEN... ) a GROUP BY 1 ORDER BY 1 LIMIT 100
Published test2

SELECT * FROM mode.crunchbase_dimension_people
Published Stanford Founders - Acquisition Price

SELECT a.stanford, COUNT(*) AS all_com...3,4,5,6,7,8 ) z ) a GROUP BY 1
Published Stanford Founders - Funding Rounds

SELECT a.founded_year, COUNT(CASE WHEN...,3,4,5,6,7 ) a GROUP BY 1 ORDER BY 1
Published Stanford Founders - Company Exits

SELECT a.stanford, COUNT(*) AS all_com...GROUP BY 1,2,3,4,5,6,7 ) a GROUP BY 1
Published Stanford Founders - Funding Round Size

SELECT a.stanford, a.funding_round_typ...5,6,7,8,9 ) a ) a GROUP BY 1,2
Published FRED embed

SELECT 1
Published Debt Ceiling Visualization

SELECT 1