Question: Write a query to retrieve the players with a batting average greater than the average batting average of their country, along with their player name,

Write a query to retrieve the players with a batting average greater than the average batting average of their country, along with their player name, country, and batting average, Order the results by the batting average in descending order.

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!

Using the Pitching table, write a query that select the playerid, teamid, Wins (W), Loss (L) and Earned Run Average (ERA) for every player (Slide 15). This query should return 49,430 rows. playerid...

Chapter 3 SQL Assignment - Part 1 The following are the queries that are to be written using the BaseBall database you created for the course. Each question is worth 5 points. Partial points will be...

Now you decide to pull all the information youve developed together. Write a query that shows the players Total_bases_touched from question #5, the batting_averages from #9 (between .2and .4999) and...

1. Using the view provided in the assignment page, write a query that uses the RANK function to rank the careerBA column where the careerBA

Learning Objectives: - reading data from a structured text file into a prograrm writing data to a structured text file from a program adding Resource Files to a Visual Studio project General...

Create and test all your queries inside Recess Save each queryin your access file using the query sumber as the queryname (so you will have queries ramadol rough I saved in Ace 00 NOT BE to generate...

9. Using a subquery along with an IN clause in the WHERE statement, write a query that identifies all the playerids, the players full name and the team names who in 2021 that were playing on teams...

Using the information below. What is the value of the food used in June? Aphil May June Ending Food Inventory Food Purchases Labor Costs Supply Costs Operating Costs Average Daily Census $11,327...

On January 1, 2011, Boston Company completed the following transactions (use a 7 percent annual interest rate for all transactions): a. Borrowed $115,000 for seven years. Will pay $8,050 interest at...

Which of the following is a tool that can provide segmentation and health validation to endpoints connecting to endpoints connecting to the network ( both remote and locally ) ? My answer Network...

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

3. Design a checklist for carrying out a safety inspection in the workplace. Use your checklist to actually carry out an inspection of a designated area either at work or in your college. Write a...

explain the terms used for companies which operate on an international basis such as international, multinational and global enterprise

5. Imagine that you are a consultant employed to select a job evaluation scheme for an organisation that employs 500 employees in a large range of clerical jobs. Write a report to the human resource...