Case study

Reporting in SQL

Tyler Pernes

Learning & Development Consultant

What is reporting?

What is reporting?

What is reporting?

What is reporting?

What is reporting?

SQL and reporting

Course goals

• Create real-world reports
• Use real-world data
• Overcome real-world obstacles

Case study

Case study

Case study

What is a dashboard?

What is a base report?

SELECT 
    country, 
    SUM(wins) AS wins
FROM game_log
GROUP BY country
ORDER BY wins DESC
LIMIT 3;

Your dashboard

Querying time!

Reporting in SQL