This project analyzes a Pizza Sales dataset to generate business insights using SQL and Excel. The dataset was first imported into SQL Server, where SQL queries were written to calculate key business ...
PIVOT Cities ON Year IN (SELECT YEAR FROM (SELECT Year, SUM(POPULATION) AS popsum FROM Cities GROUP BY Year ORDER BY popsum DESC)) USING SUM(Population); ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results