Analyzing Sachin Tendulkar's MTD Performances

Learning Objectives

Understand the use of Common Table Expressions (CTEs) to structure queries and simplify complex calculations.

Extract and manipulate date components such as the year and day-of-year using functions like EXTRACT() to perform time-based analysis.

Implement window functions to calculate cumulative totals, percentages, and rankings.

Overview

Sachin Tendulkar is a legendary player, and the BCCI has decided to dive deep into his career to gain valuable insights into his performance over different months.

In this scenario, we will analyze his Month-to-Date (MTD) performance to uncover key trends and moments that highlight his consistency and brilliance throughout the years.

Prerequisites

Knowledge of basic SQL concepts like SELECT, WHERE, GROUP BY, HAVING, ORDER BY, and JOIN.
Knowledge of aggregations using functions like SUM, COUNT, and AVG.
Knowledge of CTEs and subqueries for structuring and simplifying queries.
Knowledge of window functions like RANK(), DENSE_RANK(), ROW_NUMBER(), and SUM() OVER().