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

Getting Started
1Switch to a SQL tab and select a database
2Write or paste your SQL in the editor
3Press Alt+Enter to run
Tip:Select text in the editor to run only that portion
IPL-Matches Updated 1/1/26, 5:12 PM
Notes SQL Tab-3
Alt+Enter to run