.webp&w=3840&q=100)
Industry
sports
Skills
data-wrangling
Tools
sql
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
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 the years.
In this scenario, we will focus on finding some useful Sachin's Strike Rate Milestones
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().