This query provides a basic analysis. You would then use SSRS (SQL Server Reporting Services) or another reporting tool to create a visually appealing report.