Mastering SQL Functions and Clauses with Leo Messi

Learning SQL Scripting with Leo MessiMastering SQL Functions and Clauses with Leo Messi

Take your SQL expertise to the next level by harnessing the power of SQL functions. Using data from Messi's career, this course delves into advanced SQL functions and clauses, helping you summarize, count, and differentiate data to gain deeper insights into soccer datasets.

Lessons and practices

Lesson 1: Mastering the COUNT Function

Counting Rows in SQL

Counting Rows in Matches Table

Fix the SQL Query

Counting Rows in a Table

Counting Unique Competitions

Lesson 2: Utilizing DISTINCT for Uniqueness Exploration

Extracting Season IDs Query

Finding Unique Season IDs

Fix the Unique Season Query

Unique Match Venues Retrieval