[x] With check boxes for the tasks and any subtasks you can identify
[x] Estimates for the top-level checkboxes
[ ] Update your TIY-Assignments wiki _(S)_
[ ] End of Day:
[x] Assignment Evaluation
[ ] Lightbulbs
[ ] Things I Don’t Get Yet
[x] Create a branch in your TIY-Assignments repo, named appropriately _(S)_
[x] A Pull Request in your TIY-Assignments folder as on previous assignments _(S)_
[x] Comments on your WIP Issue as on previous assignments _(S)_
[x] Link to Wiki
[x] Link to Pull Request (in Markdown)
[x] Last night's NFL SQL queries (nflqueries.sql) **(XS)**_
[ ] NFL queries in Rails console (nflqueries.rb) **(L)**_
[x] Select every team from the NFC North
[x] Select every team with at least 11 wins
[x] Select every team with at least 8 wins that did not make the playoffs
[ ] Rename every team with fewer than 4 wins "Losers"
[ ] Select every team that plays in a city of fewer than 5 million people, and the name of the city
[x] Select every AFC team that plays in a city that is shrinking in population
[x] Select every city that has a team
[x] Select every state that has a team
[ ] Select every team that plays in California
[x] Find the 3 smallest cities with NFL teams
[x] Find the number of teams in cities of between 1 million and 2 million (as of 2013)
[ ] Find the division with the largest average number of wins
[ ] List the names of the teams of the AFC in descending order of the size of their cities
[ ] Change the name of the 5th largest city in New Jersey to include the phrase "like the inventor"
[ ] Remove New Mexico and all its cities from the database with one line in the console. You can edit a line in file in app/models too.
[ ] Next, method writing time. Try to get the effect of each of these in the console, and once you have something that works, write a method in the appropriate place. It's not the formalized testing we've been doing, but you'll see that again soon. (city.rb and team.rb) _(L)_
[x] Define a method City.fastest_growing that returns the single fastest growing city
[x] Define a method City.shrinking that returns all cities with decreasing population
[ ] Define a method Team#division_rivals that returns all other teams in the same (conference and) division
[ ] Define a method Team#division_leader? that checks whether a team has more wins than any other team in its (conference and) division
[ ] Define a method Team#division_winner? that checks whether a team leads its division and all its division rivals have played 16 games
Tasks
TIY-Assignments
wiki _(S)_TIY-Assignments
repo, named appropriately _(S)_TIY-Assignments
folder as on previous assignments _(S)_City.fastest_growing
that returns the single fastest growing cityCity.shrinking
that returns all cities with decreasing populationTeam#division_rivals
that returns all other teams in the same (conference and) divisionTeam#division_leader?
that checks whether a team has more wins than any other team in its (conference and) divisionTeam#division_winner?
that checks whether a team leads its division and all its division rivals have played 16 games