[x] With check boxes for the tasks and any subtasks you can identify
[x] Estimates for the top-level checkboxes
[x] Update your TIY-Assignments wiki (S)
[x] End of Lab (Due by 5 pm):
[x] Assignment Evaluation
[x] Lightbulbs
[x] 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] Complete the MISSQL Command and read through the documentation the site gives (L)
[x] Next, go through Zed Shaw's Learn SQL The Hard Way (lessons 1-13) to play with SQL from the terminal (L)
[x] Then go through the NFL database. There is enough data in there to formulate some interesting queries (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
[x] Rename every team with fewer than 4 wins "Losers"
[x] 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
[x] Select every team that plays in California
[x] Create a /sql directory with any sql files you created for "Learn the Hard Way", a separate file listing the queries you wrote for that tutorial saved under the name learn_the_hard_way_queries.sql, and the queries you needed to write in the sqlite console to work out all nine of the above selects saved as nfl_queries.sql (L)
TIY-Assignments
wiki (S)TIY-Assignments
repo, named appropriately (S)TIY-Assignments
folder as on previous assignments (S)/sql
directory with any sql files you created for"Learn the Hard Way"
, a separate file listing the queries you wrote for that tutorial saved under the namelearn_the_hard_way_queries.sql
, and the queries you needed to write in the sqlite console to work out all nine of the above selects saved asnfl_queries.sql
(L)