trends_startups

SELECT COUNT(*) FROM startups;
SELECT SUM(valuation) AS 'total value' FROM startups;
SELECT MAX(raised) FROM startups
WHERE stage='Seed';
SELECT MIN(founded) FROM startups;
SELECT avg(valuation) FROM startups;
SELECT category, round(avg(valuation), 2) FROM startups
GROUP BY category
ORDER BY 2 DESC;
SELECT category, COUNT(*) FROM startups
GROUP BY category
HAVING COUNT(*) > 3;
SELECT location, avg(employees) FROM startups
GROUP BY location
HAVING avg(employees) > 500;