Use desktop for interactive SQL sandbox

IPL Match Results Dataset (2017 - 2019 Season) [>_]

This dataset contains match-level results from the 2017 Indian Premier League (IPL) cricket tournament. Each row represents a single match with comprehensive details including:
Match Details: Season, date, city, venue, and competing teams
Toss Information: Which team won the toss and their decision (bat/field)
Match Outcome: Winner, margin of victory (runs or wickets), result type (normal/tie), and whether Duckworth-Lewis method was applied
Officials: Player of the match and up to three umpires


Key Fields

  • team1 / team2: Competing franchises (e.g., Sunrisers Hyderabad, Royal Challengers Bangalore)
  • win_by_runs / win_by_wickets: Margin of victory (one will be 0, the other shows margin)
  • dl_applied: Binary indicator (0/1) for weather-adjusted matches
  • venue: Specific cricket stadium where match was played

Use Cases

Analyzing team performance, toss impact, venue statistics, player awards, and match outcome patterns.


How to Get Started

Step 1: Create the Table

  • Click on the SQL tab
  • You'll see a CREATE TABLE statement with the dataset structure
  • Click "Run" to execute the DDL and create the ipl_matches table in your sandbox

Step 2: Write Your Queries

  • Switch to the next tab (Query/Practice tab)
  • Write your own SQL queries to explore the IPL data
  • Click "Run" to execute your queries and see results

That's it! The table is now ready for you to practice SQL queries and analyze IPL match data.

SQL Output

IPL-Matches
Private
This dataset contains information of IPL matches between 2017 and 2019 seasons.
jrz1977
PostgreSQL
Created Jan 1, 2026
1Notes Notes
2SQL SQL
3Tab-3 SQL
2 SQL 1 Notes
Switch to a SQL tab and press Alt+Enter to run queries
IPL-Matches Updated 1/1/26, 5:12 PM
Notes SQL Tab-3
Alt+Enter to run