Analyzing Sachin Tendulkar's Strike Rate

Learning Objectives

Apply filtering and sorting techniques to extract and present specific results

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

Demonstrate the use of Common Table Expressions (CTEs) to structure and simplify queries for better readability and organization.

Overview

The BCCI has decided to felicitate Sachin Tendulkar with a special tribute celebrating his extraordinary career. But this isn't just any ordinary ceremony—they want to honor him with insights that have never been revealed before.

As their chosen Data Analyst, you'll uncover remarkable details about Tendulkar's career that will form the centerpiece of this historic tribute. Your mission involves analyzing his phenomenal strike rate and discovering statistical milestones that showcase his true dominance against various opponents.

This is your chance to contribute to cricket history by revealing data-driven stories that will be shared at one of the sport's most prestigious celebrations. You'll use advanced analytical techniques to process authentic BCCI records and uncover patterns that even seasoned cricket experts haven't discovered.

Ready to help honor cricket's master blaster with groundbreaking insights?

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().