Implement the queries described above^Wbelow.

[greut]

A few more queries should be implemented:

• Print the last and first name of players/coaches who participated in NBA both as a player and as a coach.
• Print the last and first name of those who participated in NBA as both a player and a coach in the same season.
• Print the name of the school with the highest number of players sent to the NBA.
• Print the names of coaches who participated in both leagues (NBA and ABA).
• Compute the highest scoring and lowest scoring player for each season.
• Print the names of oldest and youngest player that have participated in the playoffs for each season.

[greut]

For the Query F can you take a look at this line as the first guy seems to have no birthdate?

1967,   1125,   Wilbert,    Frazier,    ,   3827,   Bob,    Wilson,     1926-03-08

Otherwise it looks all good from here. Good job!

[greut]

ping @nddrylliog!

[nddrylliog]

I would, but I can't run the app! Looking at the people row with id 1125 would be a lot easier from ActiveAdmin :(

[greut]

The data says it all.

players.csv (line 1126)
FRAZIWI02,Wilbert,Frazier,C,1967,1968,NULL,NULL,NULL,NULL,NULL

fyi: http://www.databasebasketball.com/players/playerpage.htm?ilkid=FRAZIWI02

[nddrylliog]

HA! Ha! Ha. I changed the Gemfile to use plain http and now bundle install works...

[greut]

another bug.

Can you explain the remark about “different join order not giving any results” in query D? Please include this explanation in the final version of the report. Keep in mind that you're not getting the correct result (should be indeed 0 rows).

[nddrylliog]

We'd have to try again, but yeah some order gave 0 results, which I thought was wrong :(

[nddrylliog]

Fixed D, closing!