SQL: answers from data
SQL: answers from data
Explore retail performance, business growth, and economic data. Open a project to see the queries and results.
Explore retail performance, business growth, and economic data. Open a project to see the queries and results.
A guided analysis of 3,179 products, joining product information with finance, brand, review, and traffic data.
Methods: PostgreSQL joins, aggregations, CASE expressions, and data completeness checks.
Finding: The Adidas “Expensive” price band generates about $4.63 million in the notebook’s dataset—the highest brand/price-band total.
Interpretation: Revenue concentration can guide further investigation, but it does not establish profitability or prove that raising prices would increase sales.
Learning project · Results describe the supplied dataset.
Compare industry valuations and the number of new unicorn companies each year from 2019 to 2021.
Focus: Industry comparisons, annual trends, and summary statistics.
Investigate the revenue streams of a motorcycle parts business.
Focus: Revenue analysis and business reporting with SQL.
Use World Bank data to investigate international debt and answer economic questions through SQL.
Focus: Public data, aggregation, and comparative analysis.