98

Player Impact Score

HardJOINarithmeticweighted formula

Problem Description

Write a SQL query to calculate player impact: (runs * 1) + (wickets * 25) + (catches * 10).

Expected Columns

  • player_name
  • team_name
  • impact_score

Example Output

| player_name | team_name | impact_score | |-------------|-----------|--------------| | Sunil Narine | Kolkata Knight Riders | 148 | | Virat Kohli | Royal Challengers | 132 | | ... | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#98 Player Impact Score
Hard

Loading schema...

Loading editor...

No results yet

Run a query to see results