Question: Trying to write SQL for the following questions. My headers are: lahmanID playerID managerID hofID birthYear birthMonth birthDay birthCountry birthState birthCity deathYear deathMonth deathDay deathCountry

Trying to write SQL for the following questions.

My headers are:

lahmanID

playerID

managerID

hofID

birthYear

birthMonth

birthDay

birthCountry

birthState

birthCity

deathYear

deathMonth

deathDay

deathCountry

deathState

deathCity

nameFirst

nameLast

nameNote

nameGiven

nameNick

weight

height

bats

throws

debut

finalGame

college

lahman40ID

lahman45ID

retroID

holtzID

bbrefID

f.Group the number of players by year of birth and then only list the top 10 years

g.List the number of players by month of birth

h.Provide a list of players with the following information: Player name and city, state, country and total salary for all years combined.

i.Provide a list of players with his age as of today

j.Provide a list of players that were inducted into the Hall of Fame

k.Provide a list of the top 10 highly paid players

l.Provide a list of all players for any team and from any year. For example, print the list of players who played for Chicago Cubs in 2000.

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!

1. List of top 50 players by highest number of home runs in the 2012 season. List the players by Player ID, First Name and Last Name, number of home runs and season year. NOTE: This is a MONGODB...

I need help making the SQL statements in visual studio 2017 Please read homework carefully svxGS0201 9 1 0/Project%20Task%2075628 1 %29.pdf MGMT 329: Database Management Project Task 7: Requi The...

Can you explain this without copy pasting another questions answer i need to learn how to write these oracle sql commands, i am not copy pasting i am trying to learn so please help me with this 10...

PIease answer questi0n 9 only. lent Students are about to graduating and trying to submit job applications to different companies like Google, Facebook, Apple, and Amazon, etc... There is a database...

Needing help creating a datamodel from the below specifications. Relationships I believe will be needed as tables are: user, bookmarks, subscriptions, tags, and cache. The specifications state that...

You will develop an E-Commerce database used to maintain customers, products and sales information. You are required to 1) gather and analyze requirements 2) design logical structure of the database...

This is a copy of my assignment it may be hard to answer considering they're all connected, but basically looking for any help possible. We use SQL server for the assignments. If i am leaving out any...

Oracle provides the ability to set expirations, limit the reuse, and define the complexity of passwords. In addition, accounts can be locked if the password is entered incorrectly too many times. In...

Create HR database with the following tables. Write SQL query for the following questions based on above database. No. Question 1. Write a SQL query to find those employees whose salaries are less...

Consider again the conditions of Exercise 10. Suppose also that in a random sample of size n = 10, it is found that n = 1 and s2n = 8. Find the shortest possible interval such that the posterior...

XII. (22 points) Consider the following items in the Knapsack Problem: 0 1 2 8 ! 0 0 0 3 40 Item 1 2 3 4 (a) $15 (b) $23 (c) $25 (d) $20 In the Fractional Knapsack Problem, what is the maximum value...

Aby owns $ 5 0 , 0 0 0 of various bond mutual funds. These funds contain bonds issued by both corporations and the U . S . government. Economic indicators signal a coming resurgence of inflation....

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Identify the ways language works to help people communicate the five functional communication competencies

The Functions of Language Problems with Language

The Nature of Language