For this Codecademy project, I used aggregate SQL functions to investigate trends in startups and gain insights to help a tech reporting company write a well-informed article.
Below is an example of the initial table:
I began by investigating data by grouping it in ways that would help the reporter reach conclusions about stats such as location, valuation, and company size.
By using SQL aggregate functions, I could extract and organize stats like the average valuation of startups in each industry:
I was also able to explore correlations in data like location and startup size:
Please see the attached file for other examples of queries used.