Question: Write a SQL query to retrieve the player names, their respective country names, and the number of runs scored by each player, along with the
Write a SQL query to retrieve the player names, their respective country names, and the number of runs scored by each player, along with the difference in runs scored between the current player and the player with the next highest number of runs. Order the results by player name in ascending order.
Tables Schema as Below:
CricketPlayer
columnName dataType
playerid INTEGER
playername TEXT
country TEXT
battingstyle TEXT
bowlingstyle TEXT
matchesplayed INTEGER
runsscored INTEGER
wicketstaken INTEGER
battingaverage DECIMAL
bowlingaverage DECIMAL
Team
columnName dataType
teamid INTEGER
teamname TEXT
country TEXT
coach TEXT
captain TEXT
playerid INTEGER
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
