This query counts how many companies are in each cap size (‘Small Cap’, ‘Mid Cap’ and ‘Large Cap’). This data is pulled from the Hubspot API into Panoply.
SELECT CASE WHEN annual_revenue < 1000000000 THEN 'Small Cap' WHEN annual_revenue < 10000000000 THEN 'Mid Cap' ELSE 'Large Cap' END AS "Cap Size" , count(company_id) AS "Count Companies" FROM hubspot_companies_consolidated GROUP BY 1;
||Bin indicating the annual revenue.|
||The number of Hubspot companies that fall into the cap size groupings.|