Question: Write an SQL query to retrieve the player names and their respective runs _ scored. For each player, find the runs _ scored of the

Write an SQL query to retrieve the player names and their respective runs_scored. For each player, find the runs_scored of the player who has the highest runs_scored before and after them in the table, considering the players are sorted by runs_scored in descending order. Order the results by runs_scored in descending order as well.
Tables Schema as Below:
CricketPlayer
columnName dataType
player_id INTEGER
player_name TEXT
country TEXT
batting_style TEXT
bowling_style TEXT
matches_played INTEGER
runs_scored INTEGER
wickets_taken INTEGER
batting_average DECIMAL(5,2)
bowling_average DECIMAL(5,2)
Team
columnName dataType
team_id INTEGER
team_name TEXT
country TEXT
coach TEXT
captain TEXT
player_id INTEGER

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

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...

Q:

Write a SQL query to retrieve the player names, their respective country names, and the number of matches played by each player, along with the number of matches played by the next player from the...

Q:

Given .sql file: create table Player ( ID integer, Name varchar(64), Birthday date, Address varchar(128), Email varchar(32), PhoneNumber char(10), PlayPos varchar(16) ); alter table Player add...

Q:

Given .sql file: create table Player ( ID integer, Name varchar(64), Birthday date, Address varchar(128), Email varchar(32), PhoneNumber char(10), PlayPos varchar(16) ); alter table Player add...

Q:

Write a query to retrieve the names of the players who have scored at least one goal, the players country, and the number of goals each player scored. Order the result by number of goals scored in...

Q:

PLEASE I NEED HELP FOR THIS ASSIGNMENT AND USE XAMPP In this homework, you will get started on how to create and use a relational DBMS. You can either use the MySQL system. You will write SQL...

Q:

Please upload your text file containing the queries used, thank you. 1. 2. 3. 4. EMPIOYEE DEPARTMENT DEPT_LOCATIONS WORKS ON PROJECT DEPENDENT Write a query to find the total salary paid in each...

Q:

Each week in the Stirling area, sporting teams meet to compete in games. More than two teams can compete in any given game and players win points for their team rather than winning a game outright....

Q:

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

Q:

Mom and POP database: Project 2 Based on the business requirements provided, the ERD would include the following entities: -Customers -Videos/DVDs -Movie -Distributors -Transactions Assignment to be...

Q:

Find bases for the eigenspaces of the matrices in Exercise 7. Exercise 7 Find the characteristic equations of the following matrices: 0001 2120 0010 0100

Q:

Calculate the interest and new balance on a credit card with an APR of 17.45% using the average daily balance method. Assume that on February 1 the balance was$ 4,578.25, day 8 is credited a payment...

Q:

Which of the following taxpayers will incur a failure - to - file penalty? Gusto fails to file his return by the due date or extended due date, has a $ 4 3 0 balance due, and presents no reasonable...

Q:

A stock price is currently $50. It is known that at the end of six months that the stock price will either increase or decrease by 9%. The risk-free interest rate is 5% per annum with continuous...

Q:

A How can hearing people become better listeners when they communicate with deaf people? How can deaf people improve their listening skills in the hearing world?

Q:

We know that manners are culturally bound (rude behavior in one culture may be acceptable behavior in another). Taking into account your culture and co-cultures (including age, gender, and so on), do...

Q:

A What kinds of activities do you know distract you and affect your ability to listen? Are there any tasks that you feel you can do without affecting your listening?