Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Last login: Thu Feb 8 14:44:14 on ttys000
- ~
- $ cd dev/ga-wdi/class-work/week-10/
- ~/dev/ga-wdi/class-work/week-10
- $ ls
- club_ruby library_sql ruby-basics-exercises
- codebar oop_monkey ruby-enumerables-exercises
- high_card rspec-shopping-exercise shopping_list
- landlord_ruby_no_AR rspec_person_example
- ~/dev/ga-wdi/class-work/week-10
- $ git clone git@git.generalassemb.ly:tomatohammado/nba_stats.git && cd nba_stats
- Cloning into 'nba_stats'...
- remote: Counting objects: 22, done.
- remote: Total 22 (delta 0), reused 0 (delta 0), pack-reused 22
- Receiving objects: 100% (22/22), 20.83 KiB | 2.31 MiB/s, done.
- Resolving deltas: 100% (6/6), done.
- ~/dev/ga-wdi/class-work/week-10/nba_stats on master
- $ createdb nba_db
- ~/dev/ga-wdi/class-work/week-10/nba_stats on master
- $ psql
- psql (10.1)
- Type "help" for help.
- ga=# \l
- List of databases
- Name | Owner | Encoding | Collate | Ctype | Access privileges
- -----------+----------+----------+-------------+-------------+-----------------------
- ga | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- library | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- nba_db | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- (6 rows)
- ga=# \q
- ~/dev/ga-wdi/class-work/week-10/nba_stats on master
- $ psql -d nba_db -f players.sql
- psql:players.sql:1: NOTICE: table "players" does not exist, skipping
- DROP TABLE
- CREATE TABLE
- ~/dev/ga-wdi/class-work/week-10/nba_stats on master
- $ ruby load_data.rb
- ~/dev/ga-wdi/class-work/week-10/nba_stats on master
- $ psql
- psql (10.1)
- Type "help" for help.
- ga=# \l
- List of databases
- Name | Owner | Encoding | Collate | Ctype | Access privileges
- -----------+----------+----------+-------------+-------------+-----------------------
- ga | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- library | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- nba_db | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- (6 rows)
- ga=# \c nba_db
- You are now connected to database "nba_db" as user "ga".
- nba_db=# \d
- List of relations
- Schema | Name | Type | Owner
- --------+----------------+----------+-------
- public | players | table | ga
- public | players_id_seq | sequence | ga
- (2 rows)
- nba_db=# SELECT * FROM players;
- id | name | age | team | games | points
- -----+---------------------+-----+------+-------+--------
- 1 | Jeff Adrien | 25 | HOU | 8 | 21
- 2 | Arron Afflalo | 26 | DEN | 62 | 943
- 3 | Blake Ahearn | 27 | UTA | 4 | 10
- 4 | Solomon Alabi | 23 | TOR | 14 | 33
- 5 | Cole Aldrich | 23 | OKC | 26 | 57
- 6 | LaMarcus Aldridge | 26 | POR | 55 | 1191
- 7 | Lavoy Allen | 22 | PHI | 41 | 169
- 8 | Ray Allen | 36 | BOS | 46 | 655
- 9 | Tony Allen | 30 | MEM | 58 | 568
- 10 | Morris Almond | 26 | WAS | 4 | 14
- 11 | Al-Farouq Aminu | 21 | NOH | 66 | 399
- 12 | Louis Amundson | 29 | IND | 60 | 213
- 13 | Chris Andersen | 33 | DEN | 32 | 168
- 14 | Alan Anderson | 29 | TOR | 17 | 163
- 15 | James Anderson | 22 | SAS | 51 | 190
- 16 | Ryan Anderson | 23 | ORL | 61 | 980
- 17 | Carmelo Anthony | 27 | NYK | 55 | 1245
- 18 | Joel Anthony | 29 | MIA | 64 | 219
- 19 | Gilbert Arenas | 30 | MEM | 17 | 72
- 20 | Trevor Ariza | 26 | NOH | 41 | 444
- 21 | Omer Asik | 25 | CHI | 66 | 205
- 22 | D.J. Augustin | 24 | CHA | 48 | 532
- 23 | Gustavo Ayon | 26 | NOH | 54 | 319
- 24 | Kelenna Azubuike | 28 | DAL | 3 | 7
- 25 | Luke Babbitt | 22 | POR | 40 | 202
- 26 | Renaldo Balkman | 27 | NYK | 14 | 42
- 27 | Leandro Barbosa | 29 | TOR | 42 | 512
- 28 | Jose Barea | 27 | MIN | 41 | 463
- 29 | Andrea Bargnani | 26 | TOR | 31 | 603
- 30 | Matt Barnes | 31 | LAL | 63 | 491
- 31 | Earl Barron | 30 | GSW | 2 | 4
- 32 | Brandon Bass | 26 | BOS | 59 | 738
- 33 | Tony Battie | 35 | PHI | 27 | 42
- 34 | Shane Battier | 33 | MIA | 65 | 311
- 35 | Nicolas Batum | 23 | POR | 59 | 818
- 36 | Jerryd Bayless | 23 | TOR | 31 | 353
- 37 | Michael Beasley | 23 | MIN | 47 | 541
- 38 | Rodrigue Beaubois | 23 | DAL | 53 | 472
- 39 | Marco Belinelli | 25 | NOH | 66 | 780
- 40 | Raja Bell | 35 | UTA | 34 | 217
- 41 | Keith Benson | 23 | GSW | 3 | 0
- 42 | Mike Bibby | 33 | NYK | 39 | 103
- 43 | Andris Biedrins | 25 | GSW | 47 | 79
- 44 | Chauncey Billups | 35 | LAC | 20 | 299
- 45 | Bismack Biyombo | 19 | CHA | 63 | 327
- 46 | DeJuan Blair | 22 | SAS | 64 | 611
- 47 | Steve Blake | 31 | LAL | 53 | 276
- 48 | Andray Blatche | 25 | WAS | 26 | 221
- 49 | Eric Bledsoe | 22 | LAC | 40 | 132
- 50 | Keith Bogans | 31 | NJN | 5 | 21
- 51 | Andrew Bogut | 27 | MIL | 12 | 136
- 52 | Matt Bonner | 31 | SAS | 65 | 429
- 53 | Trevor Booker | 24 | WAS | 50 | 419
- 54 | Carlos Boozer | 30 | CHI | 66 | 991
- 55 | Chris Bosh | 27 | MIA | 57 | 1025
- 56 | Earl Boykins | 35 | HOU | 8 | 39
- 57 | Craig Brackins | 24 | PHI | 14 | 22
- 58 | Avery Bradley | 21 | BOS | 64 | 484
- 59 | Elton Brand | 32 | PHI | 60 | 659
- 60 | Corey Brewer | 25 | DEN | 59 | 525
- 61 | Ronnie Brewer | 26 | CHI | 66 | 455
- 62 | Jon Brockman | 24 | MIL | 35 | 37
- 63 | MarShon Brooks | 23 | NJN | 56 | 708
- 64 | Derrick Brown | 24 | CHA | 65 | 524
- 65 | Kwame Brown | 29 | GSW | 9 | 57
- 66 | Shannon Brown | 26 | PHO | 59 | 650
- 67 | Kobe Bryant | 33 | LAL | 58 | 1616
- 68 | Chase Budinger | 23 | HOU | 58 | 558
- 69 | Alec Burks | 20 | UTA | 59 | 425
- 70 | Caron Butler | 31 | LAC | 63 | 753
- 71 | Jimmy Butler | 22 | CHI | 42 | 109
- 72 | Rasual Butler | 32 | TOR | 34 | 110
- 73 | Derrick Byars | 27 | SAS | 2 | 10
- 74 | Andrew Bynum | 24 | LAL | 60 | 1123
- 75 | Will Bynum | 29 | DET | 36 | 204
- 76 | Jose Calderon | 30 | TOR | 53 | 555
- 77 | Marcus Camby | 37 | POR | 40 | 152
- 78 | Brian Cardinal | 34 | DAL | 44 | 43
- 79 | DeMarre Carroll | 25 | DEN | 4 | 12
- 80 | Matt Carroll | 31 | CHA | 53 | 142
- 81 | Anthony Carter | 36 | TOR | 24 | 47
- 82 | Vince Carter | 35 | DAL | 61 | 615
- 83 | Omri Casspi | 23 | CLE | 65 | 459
- 84 | Mario Chalmers | 25 | MIA | 64 | 627
- 85 | Tyson Chandler | 29 | NYK | 62 | 699
- 86 | Wilson Chandler | 24 | DEN | 8 | 75
- 87 | Josh Childress | 28 | PHO | 34 | 100
- 88 | Earl Clark | 24 | ORL | 45 | 123
- 89 | Norris Cole | 23 | MIA | 65 | 441
- 90 | Jason Collins | 33 | ATL | 30 | 39
- 91 | Darren Collison | 24 | IND | 60 | 621
- 92 | Nick Collison | 31 | OKC | 63 | 284
- 93 | Mike Conley | 24 | MEM | 62 | 788
- 94 | Brian Cook | 31 | LAC | 16 | 31
- 95 | Daequan Cook | 24 | OKC | 57 | 311
- 96 | DeMarcus Cousins | 21 | SAC | 64 | 1160
- 97 | Jamal Crawford | 31 | POR | 60 | 837
- 98 | Jordan Crawford | 23 | WAS | 64 | 938
- 99 | Dante Cunningham | 24 | MEM | 64 | 333
- 100 | Eddy Curry | 29 | MIA | 14 | 30
- 101 | Stephen Curry | 23 | GSW | 26 | 383
- 102 | Samuel Dalembert | 30 | HOU | 65 | 490
- 103 | Erick Dampier | 36 | ATL | 15 | 2
- 104 | Marquis Daniels | 31 | BOS | 38 | 121
- 105 | Baron Davis | 32 | NYK | 29 | 178
- 106 | Ed Davis | 22 | TOR | 66 | 415
- 107 | Glen Davis | 26 | ORL | 61 | 566
- 108 | Josh Davis | 31 | MEM | 15 | 28
- 109 | Eric Dawson | 27 | SAS | 4 | 15
- 110 | Austin Daye | 23 | DET | 41 | 194
- 111 | Carlos Delfino | 29 | MIL | 54 | 488
- 112 | Luol Deng | 26 | CHI | 54 | 828
- 113 | Justin Dentmon | 26 | SAS | 2 | 4
- 114 | DeMar DeRozan | 22 | TOR | 63 | 1054
- 115 | Boris Diaw | 29 | CHA | 37 | 272
- 116 | Ike Diogu | 28 | SAS | 2 | 2
- 117 | DeSagana Diop | 30 | CHA | 27 | 31
- 118 | Keyon Dooling | 31 | BOS | 46 | 182
- 119 | Toney Douglas | 25 | NYK | 38 | 237
- 120 | Goran Dragic | 25 | HOU | 66 | 775
- 121 | Jared Dudley | 26 | PHO | 65 | 823
- 122 | Chris Duhon | 29 | ORL | 63 | 237
- 123 | Tim Duncan | 35 | SAS | 58 | 895
- 124 | Mike Dunleavy | 31 | MIL | 55 | 677
- 125 | Kevin Durant | 23 | OKC | 66 | 1850
- 126 | Jerome Dyson | 24 | NOH | 9 | 67
- 127 | Devin Ebanks | 22 | LAL | 24 | 97
- 128 | Wayne Ellington | 24 | MIN | 51 | 311
- 129 | Monta Ellis | 26 | GSW | 37 | 811
- 130 | Francisco Elson | 35 | PHI | 5 | 2
- 131 | Andre Emmett | 29 | NJN | 6 | 13
- 132 | Semih Erden | 25 | CLE | 28 | 99
- 133 | Jeremy Evans | 24 | UTA | 29 | 62
- 134 | Maurice Evans | 33 | WAS | 24 | 117
- 135 | Reggie Evans | 31 | LAC | 56 | 104
- 136 | Tyreke Evans | 22 | SAC | 63 | 1037
- 137 | Christian Eyenga | 22 | CLE | 6 | 9
- 138 | Kenneth Faried | 22 | DEN | 46 | 471
- 139 | Jordan Farmar | 25 | NJN | 39 | 406
- 140 | Derrick Favors | 20 | UTA | 65 | 570
- 141 | Raymond Felton | 27 | POR | 60 | 684
- 142 | Rudy Fernandez | 26 | DEN | 31 | 268
- 143 | Kyrylo Fesenko | 25 | IND | 3 | 8
- 144 | Landry Fields | 23 | NYK | 66 | 580
- 145 | Derek Fisher | 37 | LAL | 43 | 252
- 146 | Jonny Flynn | 22 | HOU | 11 | 37
- 147 | Jeff Foote | 24 | NOH | 4 | 4
- 148 | Gary Forbes | 26 | TOR | 48 | 319
- 149 | T.J. Ford | 28 | SAS | 14 | 51
- 150 | Courtney Fortson | 23 | LAC | 4 | 17
- 151 | Jeff Foster | 35 | IND | 11 | 25
- 152 | Randy Foye | 28 | LAC | 65 | 712
- 153 | Jimmer Fredette | 22 | SAC | 61 | 462
- 154 | Channing Frye | 28 | PHO | 64 | 674
- 155 | Dan Gadzuric | 33 | NYK | 2 | 0
- 156 | Sundiata Gaines | 25 | NJN | 57 | 291
- 157 | Danilo Gallinari | 23 | DEN | 43 | 628
- 158 | Francisco Garcia | 30 | SAC | 49 | 234
- 159 | Kevin Garnett | 35 | BOS | 60 | 947
- 160 | Marc Gasol | 27 | MEM | 65 | 952
- 161 | Pau Gasol | 31 | LAL | 65 | 1129
- 162 | Rudy Gay | 25 | MEM | 65 | 1232
- 163 | Alonzo Gee | 24 | CLE | 63 | 665
- 164 | Paul George | 21 | IND | 66 | 798
- 165 | Daniel Gibson | 25 | CLE | 35 | 263
- 166 | Taj Gibson | 26 | CHI | 63 | 484
- 167 | Manu Ginobili | 34 | SAS | 34 | 440
- 168 | Mickell Gladness | 25 | MIA | 8 | 2
- 169 | Ryan Gomes | 29 | LAC | 32 | 74
- 170 | Drew Gooden | 30 | MIL | 56 | 766
- 171 | Ben Gordon | 28 | DET | 52 | 648
- 172 | Eric Gordon | 23 | NOH | 9 | 185
- 173 | Marcin Gortat | 27 | PHO | 66 | 1017
- 174 | Andrew Goudelock | 23 | LAL | 40 | 175
- 175 | Danny Granger | 28 | IND | 62 | 1159
- 176 | Aaron Gray | 27 | TOR | 49 | 191
- 177 | Danny Green | 24 | SAS | 66 | 603
- 178 | Gerald Green | 26 | NJN | 31 | 400
- 179 | Willie Green | 30 | ATL | 53 | 404
- 180 | Donte Greene | 23 | SAC | 53 | 285
- 181 | Blake Griffin | 22 | LAC | 66 | 1368
- 182 | Hamed Haddadi | 26 | MEM | 35 | 70
- 183 | Jordan Hamilton | 21 | DEN | 26 | 115
- 184 | Richard Hamilton | 33 | CHI | 28 | 326
- 185 | Tyler Hansbrough | 26 | IND | 66 | 614
- 186 | Luke Harangody | 24 | CLE | 21 | 60
- 187 | James Harden | 22 | OKC | 62 | 1044
- 188 | Justin Harper | 22 | ORL | 14 | 20
- 189 | Josh Harrellson | 22 | NYK | 37 | 162
- 190 | Al Harrington | 31 | DEN | 64 | 910
- 191 | Devin Harris | 28 | UTA | 63 | 715
- 192 | Manny Harris | 22 | CLE | 26 | 173
- 193 | Terrel Harris | 24 | MIA | 22 | 80
- 194 | Tobias Harris | 19 | MIL | 42 | 208
- 195 | Udonis Haslem | 31 | MIA | 64 | 385
- 196 | Spencer Hawes | 23 | PHI | 37 | 355
- 197 | Chuck Hayes | 28 | SAC | 54 | 172
- 198 | Gordon Hayward | 21 | UTA | 66 | 782
- 199 | Lazar Hayward | 25 | OKC | 26 | 37
- 200 | Brendan Haywood | 32 | DAL | 54 | 281
- 201 | Gerald Henderson | 24 | CHA | 55 | 830
- 202 | Xavier Henry | 20 | NOH | 45 | 239
- 203 | Roy Hibbert | 25 | IND | 65 | 834
- 204 | J.J. Hickson | 23 | SAC | 35 | 165
- 205 | Cory Higgins | 22 | CHA | 38 | 150
- 206 | Nene Hilario | 29 | DEN | 28 | 376
- 207 | George Hill | 25 | IND | 50 | 481
- 208 | Grant Hill | 39 | PHO | 49 | 499
- 209 | Jordan Hill | 24 | HOU | 32 | 161
- 210 | Kirk Hinrich | 31 | ATL | 48 | 316
- 211 | Darington Hobson | 24 | MIL | 5 | 4
- 212 | Jrue Holiday | 21 | PHI | 65 | 879
- 213 | Ryan Hollins | 27 | CLE | 24 | 89
- 214 | Tyler Honeycutt | 21 | SAC | 15 | 20
- 215 | Al Horford | 25 | ATL | 11 | 136
- 216 | Dennis Horner | 23 | NJN | 8 | 5
- 217 | Dwight Howard | 26 | ORL | 54 | 1113
- 218 | Josh Howard | 31 | UTA | 43 | 372
- 219 | Juwan Howard | 38 | MIA | 28 | 42
- 220 | Lester Hudson | 27 | CLE | 13 | 165
- 221 | Larry Hughes | 33 | ORL | 9 | 12
- 222 | Kris Humphries | 26 | NJN | 62 | 855
- 223 | Serge Ibaka | 22 | OKC | 66 | 603
- 224 | Andre Iguodala | 28 | PHI | 62 | 771
- 225 | Ersan Ilyasova | 24 | MIL | 60 | 782
- 226 | Kyrie Irving | 19 | CLE | 51 | 944
- 227 | Royal Ivey | 30 | OKC | 34 | 71
- 228 | Jarrett Jack | 28 | NOH | 45 | 700
- 229 | Reggie Jackson | 21 | OKC | 45 | 140
- 230 | Stephen Jackson | 33 | MIL | 26 | 274
- 231 | Damion James | 24 | NJN | 7 | 34
- 232 | LeBron James | 27 | MIA | 62 | 1683
- 233 | Mike James | 36 | CHI | 11 | 53
- 234 | Antawn Jamison | 35 | CLE | 65 | 1118
- 235 | Al Jefferson | 27 | UTA | 61 | 1170
- 236 | Richard Jefferson | 31 | SAS | 41 | 379
- 237 | Jared Jeffries | 30 | NYK | 39 | 170
- 238 | Charles Jenkins | 22 | GSW | 51 | 297
- 239 | Brandon Jennings | 22 | MIL | 66 | 1260
- 240 | Jonas Jerebko | 24 | DET | 64 | 556
- 241 | Yi Jianlian | 24 | DAL | 30 | 79
- 242 | Amir Johnson | 24 | TOR | 64 | 452
- 243 | Armon Johnson | 22 | POR | 1 | 2
- 244 | Carldell Johnson | 29 | NOH | 15 | 27
- 245 | Chris Johnson | 26 | POR | 20 | 32
- 246 | Ivan Johnson | 27 | ATL | 56 | 356
- 247 | JaJuan Johnson | 22 | BOS | 36 | 114
- 248 | James Johnson | 24 | TOR | 62 | 566
- 249 | Joe Johnson | 30 | ATL | 60 | 1129
- 250 | Trey Johnson | 27 | NOH | 11 | 21
- 251 | Wesley Johnson | 24 | MIN | 65 | 393
- 252 | Dahntay Jones | 31 | IND | 65 | 346
- 253 | Dominique Jones | 23 | DAL | 33 | 88
- 254 | James Jones | 31 | MIA | 51 | 185
- 255 | Solomon Jones | 27 | LAC | 10 | 6
- 256 | DeAndre Jordan | 23 | LAC | 66 | 486
- 257 | Jerome Jordan | 25 | NYK | 21 | 42
- 258 | Cory Joseph | 20 | SAS | 29 | 58
- 259 | Chris Kaman | 29 | NOH | 47 | 616
- 260 | Enes Kanter | 19 | UTA | 66 | 304
- 261 | Jason Kapono | 30 | LAL | 27 | 54
- 262 | D.J. Kennedy | 22 | CLE | 2 | 12
- 263 | Jason Kidd | 38 | DAL | 48 | 299
- 264 | Linas Kleiza | 27 | TOR | 49 | 473
- 265 | Brandon Knight | 20 | DET | 66 | 847
- 266 | Kyle Korver | 30 | CHI | 65 | 529
- 267 | Kosta Koufos | 22 | DEN | 48 | 263
- 268 | Carl Landry | 28 | NOH | 41 | 511
- 269 | Ty Lawson | 24 | DEN | 61 | 999
- 270 | Courtney Lee | 26 | HOU | 58 | 660
- 271 | David Lee | 28 | GSW | 57 | 1147
- 272 | Malcolm Lee | 21 | MIN | 19 | 62
- 273 | Kawhi Leonard | 20 | SAS | 64 | 507
- 274 | Travis Leslie | 21 | LAC | 10 | 14
- 275 | Jon Leuer | 22 | MIL | 46 | 218
- 276 | Rashard Lewis | 32 | WAS | 28 | 217
- 277 | DeAndre Liggins | 23 | ORL | 17 | 33
- 278 | Jeremy Lin | 23 | NYK | 35 | 512
- 279 | Shaun Livingston | 26 | MIL | 58 | 318
- 280 | Brook Lopez | 23 | NJN | 5 | 96
- 281 | Robin Lopez | 23 | PHO | 64 | 348
- 282 | Kevin Love | 23 | MIN | 55 | 1432
- 283 | Kyle Lowry | 25 | HOU | 47 | 670
- 284 | John Lucas | 29 | CHI | 49 | 369
- 285 | Shelvin Mack | 22 | WAS | 64 | 230
- 286 | Vernon Macklin | 25 | DET | 23 | 46
- 287 | Corey Maggette | 32 | CHA | 32 | 480
- 288 | Jamaal Magloire | 33 | TOR | 34 | 41
- 289 | Ian Mahinmi | 25 | DAL | 61 | 354
- 290 | Shawn Marion | 33 | DAL | 63 | 670
- 291 | Cartier Martin | 27 | WAS | 17 | 158
- 292 | Kenyon Martin | 34 | LAC | 42 | 217
- 293 | Kevin Martin | 28 | HOU | 40 | 682
- 294 | Roger Mason | 31 | WAS | 52 | 286
- 295 | Wesley Matthews | 25 | POR | 66 | 904
- 296 | Jason Maxiell | 28 | DET | 65 | 424
- 297 | Eric Maynor | 24 | OKC | 9 | 38
- 298 | O.J. Mayo | 24 | MEM | 66 | 833
- 299 | Luc Mbah a Moute | 25 | MIL | 43 | 333
- 300 | JaVale McGee | 24 | WAS | 41 | 486
- 301 | Tracy McGrady | 32 | ATL | 52 | 273
- 302 | Dominic McGuire | 26 | GSW | 64 | 227
- 303 | Josh McRoberts | 24 | LAL | 50 | 138
- 304 | Jodie Meeks | 24 | PHI | 66 | 556
- 305 | C.J. Miles | 24 | UTA | 56 | 508
- 306 | Darko Milicic | 26 | MIN | 29 | 134
- 307 | Andre Miller | 35 | DEN | 66 | 639
- 308 | Brad Miller | 35 | MIN | 15 | 35
- 309 | Mike Miller | 31 | MIA | 39 | 237
- 310 | Patrick Mills | 23 | SAS | 16 | 165
- 311 | Paul Millsap | 26 | UTA | 64 | 1061
- 312 | Nazr Mohammed | 34 | OKC | 63 | 171
- 313 | Greg Monroe | 21 | DET | 66 | 1015
- 314 | Jamario Moon | 31 | CHA | 8 | 18
- 315 | ETwaun Moore | 22 | BOS | 38 | 110
- 316 | Mikki Moore | 36 | GSW | 7 | 24
- 317 | Darius Morris | 21 | LAL | 19 | 46
- 318 | Marcus Morris | 22 | HOU | 17 | 40
- 319 | Markieff Morris | 22 | PHO | 63 | 467
- 320 | Anthony Morrow | 26 | NJN | 62 | 747
- 321 | Timofey Mozgov | 25 | DEN | 44 | 239
- 322 | Byron Mullens | 22 | CHA | 65 | 606
- 323 | Troy Murphy | 31 | LAL | 59 | 188
- 324 | Hamady NDiaye | 25 | WAS | 3 | 0
- 325 | Eduardo Najera | 35 | CHA | 22 | 58
- 326 | Steve Nash | 37 | PHO | 62 | 772
- 327 | Gary Neal | 27 | SAS | 56 | 557
- 328 | Jameer Nelson | 29 | ORL | 57 | 676
- 329 | Joakim Noah | 26 | CHI | 64 | 652
- 330 | Andres Nocioni | 32 | PHI | 11 | 17
- 331 | Steve Novak | 28 | NYK | 54 | 477
- 332 | Dirk Nowitzki | 33 | DAL | 62 | 1342
- 333 | Jermaine ONeal | 33 | BOS | 25 | 125
- 334 | Lamar Odom | 32 | DAL | 50 | 332
- 335 | Emeka Okafor | 29 | NOH | 27 | 266
- 336 | Mehmet Okur | 32 | NJN | 17 | 130
- 337 | Daniel Orton | 21 | ORL | 16 | 45
- 338 | Travis Outlaw | 27 | SAC | 39 | 167
- 339 | Larry Owens | 29 | NJN | 7 | 13
- 340 | Zaza Pachulia | 27 | ATL | 58 | 455
- 341 | Jannero Pargo | 32 | ATL | 50 | 282
- 342 | Jeremy Pargo | 25 | MEM | 44 | 126
- 343 | Anthony Parker | 36 | CLE | 51 | 367
- 344 | Tony Parker | 29 | SAS | 60 | 1095
- 345 | Chandler Parsons | 23 | HOU | 63 | 599
- 346 | Patrick Patterson | 22 | HOU | 64 | 490
- 347 | Chris Paul | 26 | LAC | 60 | 1189
- 348 | Sasha Pavlovic | 28 | BOS | 45 | 120
- 349 | Nikola Pekovic | 26 | MIN | 47 | 651
- 350 | Jeff Pendergraph | 24 | IND | 20 | 34
- 351 | Kendrick Perkins | 27 | OKC | 65 | 329
- 352 | Johan Petro | 26 | NJN | 59 | 250
- 353 | Paul Pierce | 34 | BOS | 61 | 1181
- 354 | Mickael Pietrus | 29 | BOS | 42 | 289
- 355 | Dexter Pittman | 23 | MIA | 35 | 106
- 356 | Quincy Pondexter | 23 | MEM | 64 | 271
- 357 | A.J. Price | 25 | IND | 44 | 172
- 358 | Ronnie Price | 28 | PHO | 36 | 131
- 359 | Tayshaun Prince | 31 | DET | 63 | 798
- 360 | Joel Przybilla | 32 | POR | 27 | 55
- nba_db=# \q
- ~/dev/ga-wdi/class-work/week-10/nba_stats on master
- $ ls
- data.csv players.sql sql_commands.txt
- load_data.rb readme.md
- ~/dev/ga-wdi/class-work/week-10/nba_stats on master
- $ git status
- On branch master
- Your branch is up to date with 'origin/master'.
- nothing to commit, working tree clean
- ~/dev/ga-wdi/class-work/week-10/nba_stats on master
- $ git checkout -b hw-mvp
- Switched to a new branch 'hw-mvp'
- ~/dev/ga-wdi/class-work/week-10/nba_stats on hw-mvp
- $ code .
- ~/dev/ga-wdi/class-work/week-10/nba_stats on hw-mvp
- $ psql
- psql (10.1)
- Type "help" for help.
- ga=# \l
- List of databases
- Name | Owner | Encoding | Collate | Ctype | Access privileges
- ------------------+----------+----------+-------------+-------------+-----------------------
- ga | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- library | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- nba_db | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
- | | | | | postgres=CTc/postgres
- tunr_development | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- tunr_test | ga | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
- (8 rows)
- ga=# \c nba_db
- You are now connected to database "nba_db" as user "ga".
- nba_db=# \d
- List of relations
- Schema | Name | Type | Owner
- --------+----------------+----------+-------
- public | players | table | ga
- public | players_id_seq | sequence | ga
- (2 rows)
- nba_db=# SELECT * FROM players;
- id | name | age | team | games | points
- -----+---------------------+-----+------+-------+--------
- 1 | Jeff Adrien | 25 | HOU | 8 | 21
- 2 | Arron Afflalo | 26 | DEN | 62 | 943
- 3 | Blake Ahearn | 27 | UTA | 4 | 10
- 4 | Solomon Alabi | 23 | TOR | 14 | 33
- 5 | Cole Aldrich | 23 | OKC | 26 | 57
- 6 | LaMarcus Aldridge | 26 | POR | 55 | 1191
- 7 | Lavoy Allen | 22 | PHI | 41 | 169
- 8 | Ray Allen | 36 | BOS | 46 | 655
- 9 | Tony Allen | 30 | MEM | 58 | 568
- 10 | Morris Almond | 26 | WAS | 4 | 14
- 11 | Al-Farouq Aminu | 21 | NOH | 66 | 399
- 12 | Louis Amundson | 29 | IND | 60 | 213
- 13 | Chris Andersen | 33 | DEN | 32 | 168
- 14 | Alan Anderson | 29 | TOR | 17 | 163
- 15 | James Anderson | 22 | SAS | 51 | 190
- 16 | Ryan Anderson | 23 | ORL | 61 | 980
- 17 | Carmelo Anthony | 27 | NYK | 55 | 1245
- 18 | Joel Anthony | 29 | MIA | 64 | 219
- 19 | Gilbert Arenas | 30 | MEM | 17 | 72
- 20 | Trevor Ariza | 26 | NOH | 41 | 444
- 21 | Omer Asik | 25 | CHI | 66 | 205
- 22 | D.J. Augustin | 24 | CHA | 48 | 532
- 23 | Gustavo Ayon | 26 | NOH | 54 | 319
- 24 | Kelenna Azubuike | 28 | DAL | 3 | 7
- 25 | Luke Babbitt | 22 | POR | 40 | 202
- 26 | Renaldo Balkman | 27 | NYK | 14 | 42
- 27 | Leandro Barbosa | 29 | TOR | 42 | 512
- nba_db=# SELECT * FROM players WHERE team = 'IND' AND age < 26;
- id | name | age | team | games | points
- -----+------------------+-----+------+-------+--------
- 91 | Darren Collison | 24 | IND | 60 | 621
- 143 | Kyrylo Fesenko | 25 | IND | 3 | 8
- 164 | Paul George | 21 | IND | 66 | 798
- 203 | Roy Hibbert | 25 | IND | 65 | 834
- 207 | George Hill | 25 | IND | 50 | 481
- 350 | Jeff Pendergraph | 24 | IND | 20 | 34
- 357 | A.J. Price | 25 | IND | 44 | 172
- 403 | Lance Stephenson | 21 | IND | 42 | 106
- (8 rows)
- nba_db=# SELECT * FROM players ORDER BY score;
- ERROR: column "score" does not exist
- LINE 1: SELECT * FROM players ORDER BY score;
- ^
- nba_db=# SELECT * FROM players ORDER BY points;
- id | name | age | team | games | points
- -----+---------------------+-----+------+-------+--------
- 324 | Hamady NDiaye | 25 | WAS | 3 | 0
- 155 | Dan Gadzuric | 33 | NYK | 2 | 0
- 390 | Brian Skinner | 35 | MEM | 1 | 0
- 41 | Keith Benson | 23 | GSW | 3 | 0
- 417 | Malcolm Thomas | 23 | SAS | 3 | 1
- 168 | Mickell Gladness | 25 | MIA | 8 | 2
- 103 | Erick Dampier | 36 | ATL | 15 | 2
- 130 | Francisco Elson | 35 | PHI | 5 | 2
- 243 | Armon Johnson | 22 | POR | 1 | 2
- 116 | Ike Diogu | 28 | SAS | 2 | 2
- 147 | Jeff Foote | 24 | NOH | 4 | 4
- 113 | Justin Dentmon | 26 | SAS | 2 | 4
- 31 | Earl Barron | 30 | GSW | 2 | 4
- 434 | Ben Uzoh | 23 | CLE | 2 | 4
- 211 | Darington Hobson | 24 | MIL | 5 | 4
- 216 | Dennis Horner | 23 | NJN | 8 | 5
- 413 | Hasheem Thabeet | 24 | HOU | 5 | 6
- 255 | Solomon Jones | 27 | LAC | 10 | 6
- 427 | Ronny Turiaf | 29 | WAS | 4 | 6
- 397 | Jerry Smith | 24 | NJN | 5 | 7
- 24 | Kelenna Azubuike | 28 | DAL | 3 | 7
- 143 | Kyrylo Fesenko | 25 | IND | 3 | 8
- 366 | Ryan Reid | 25 | OKC | 5 | 8
- 137 | Christian Eyenga | 22 | CLE | 6 | 9
- 73 | Derrick Byars | 27 | SAS | 2 | 10
- 3 | Blake Ahearn | 27 | UTA | 4 | 10
- 386 | Xavier Silas | 24 | PHI | 2 | 11
- 447 | Luke Walton | 31 | LAL | 9 | 12
- 221 | Larry Hughes | 33 | ORL | 9 | 12
- 262 | D.J. Kennedy | 22 | CLE | 2 | 12
- 79 | DeMarre Carroll | 25 | DEN | 4 | 12
- 131 | Andre Emmett | 29 | NJN | 6 | 13
- 339 | Larry Owens | 29 | NJN | 7 | 13
- 393 | Greg Smith | 21 | HOU | 8 | 14
- 274 | Travis Leslie | 21 | LAC | 10 | 14
- 10 | Morris Almond | 26 | WAS | 4 | 14
- 431 | Edwin Ubiles | 25 | WAS | 4 | 14
- 109 | Eric Dawson | 27 | SAS | 4 | 15
- 150 | Courtney Fortson | 23 | LAC | 4 | 17
- 330 | Andres Nocioni | 32 | PHI | 11 | 17
- 314 | Jamario Moon | 31 | CHA | 8 | 18
- 422 | Mychel Thompson | 23 | CLE | 5 | 18
- 214 | Tyler Honeycutt | 21 | SAC | 15 | 20
- 188 | Justin Harper | 22 | ORL | 14 | 20
- 250 | Trey Johnson | 27 | NOH | 11 | 21
- 50 | Keith Bogans | 31 | NJN | 5 | 21
- 1 | Jeff Adrien | 25 | HOU | 8 | 21
- 57 | Craig Brackins | 24 | PHI | 14 | 22
- 449 | Darryl Watkins | 27 | NOH | 5 | 23
- 316 | Mikki Moore | 36 | GSW | 7 | 24
- nba_db=# SELECT name, points FROM players ORDER BY points DESC LIMIT 20;
- name | points
- -------------------+--------
- Kevin Durant | 1850
- LeBron James | 1683
- Kobe Bryant | 1616
- Russell Westbrook | 1558
- Kevin Love | 1432
- Blake Griffin | 1368
- Dirk Nowitzki | 1342
- Brandon Jennings | 1260
- Carmelo Anthony | 1245
- Josh Smith | 1239
- Rudy Gay | 1232
- LaMarcus Aldridge | 1191
- Chris Paul | 1189
- Paul Pierce | 1181
- Al Jefferson | 1170
- DeMarcus Cousins | 1160
- Danny Granger | 1159
- Deron Williams | 1154
- David Lee | 1147
- Pau Gasol | 1129
- (20 rows)
- nba_db=# SELECT name, points FROM players ORDER BY points DESC LIMIT 20;
- name | points
- -------------------+--------
- Kevin Durant | 1850
- LeBron James | 1683
- Kobe Bryant | 1616
- Russell Westbrook | 1558
- Kevin Love | 1432
- Blake Griffin | 1368
- Dirk Nowitzki | 1342
- Brandon Jennings | 1260
- Carmelo Anthony | 1245
- Josh Smith | 1239
- Rudy Gay | 1232
- LaMarcus Aldridge | 1191
- Chris Paul | 1189
- Paul Pierce | 1181
- Al Jefferson | 1170
- DeMarcus Cousins | 1160
- Danny Granger | 1159
- Deron Williams | 1154
- David Lee | 1147
- Pau Gasol | 1129
- (20 rows)
- nba_db=# SELECT AVG(age) FROM players;
- avg
- ---------------------
- 26.6443514644351464
- (1 row)
- nba_db=# SELECT AVG(age) FROM players WHERE team = 'OKC';
- avg
- ---------------------
- 25.4000000000000000
- (1 row)
- nba_db=# SELECT AVG(age) FROM players WHERE games > 40;
- avg
- ---------------------
- 26.4561403508771930
- (1 row)
- nba_db=# SELECT name, points FROM players ORDER BY points DESC LIMIT 20;
- name | points
- -------------------+--------
- Kevin Durant | 1850
- LeBron James | 1683
- Kobe Bryant | 1616
- Russell Westbrook | 1558
- Kevin Love | 1432
- Blake Griffin | 1368
- Dirk Nowitzki | 1342
- Brandon Jennings | 1260
- Carmelo Anthony | 1245
- Josh Smith | 1239
- Rudy Gay | 1232
- LaMarcus Aldridge | 1191
- Chris Paul | 1189
- Paul Pierce | 1181
- Al Jefferson | 1170
- DeMarcus Cousins | 1160
- Danny Granger | 1159
- Deron Williams | 1154
- David Lee | 1147
- Pau Gasol | 1129
- (20 rows)
- nba_db=# SELECT AVG(age) FROM players;
- avg
- ---------------------
- 26.6443514644351464
- (1 row)
- nba_db=# SELECT team, SUM(points) FROM players ORDER BY SUM(points);
- ERROR: column "players.team" must appear in the GROUP BY clause or be used in an aggregate function
- LINE 1: SELECT team, SUM(points) FROM players ORDER BY SUM(points);
- ^
- nba_db=# SELECT SUM(points) FROM players GROUP BY team ORDER BY SUM(points);
- sum
- ------
- 5739
- 5820
- 5856
- 5887
- 5971
- 5997
- 6005
- 6009
- 6035
- 6090
- 6097
- 6140
- 6170
- 6200
- 6224
- 6253
- 6260
- 6321
- 6322
- 6359
- 6359
- 6369
- 6455
- 6458
- 6464
- 6482
- 6492
- nba_db=# SELECT team, SUM(points) FROM players GROUP BY team ORDER BY SUM(points);
- team | sum
- team | sum
- ------+------
- CHA | 5739
- NOH | 5820
- NJN | 5856
- TOR | 5887
- WAS | 5971
- DET | 5997
- POR | 6005
- BOS | 6009
- MIL | 6035
- LAL | 6090
- CLE | 6097
- PHI | 6140
- ORL | 6170
- GSW | 6200
- LAC | 6224
- IND | 6253
- MEM | 6260
- HOU | 6321
- DAL | 6322
- CHI | 6359
- SAC | 6359
- ATL | 6369
- MIA | 6455
- NYK | 6458
- MIN | 6464
- UTA | 6482
- PHO | 6492
- nba_db=# SELECT team, SUM(points) AS total_points FROM players GROUP BY team ORDER BY SUM(points);
- team | total_points
- ------+--------------
- CHA | 5739
- NOH | 5820
- NJN | 5856
- TOR | 5887
- WAS | 5971
- DET | 5997
- POR | 6005
- BOS | 6009
- MIL | 6035
- LAL | 6090
- CLE | 6097
- PHI | 6140
- ORL | 6170
- GSW | 6200
- LAC | 6224
- IND | 6253
- MEM | 6260
- HOU | 6321
- DAL | 6322
- CHI | 6359
- SAC | 6359
- ATL | 6369
- MIA | 6455
- NYK | 6458
- MIN | 6464
- UTA | 6482
- PHO | 6492
- nba_db=# SELECT AVG(age) AS avg_age FROM players WHERE games > 40;
- avg_age
- ---------------------
- 26.4561403508771930
- (1 row)
- nba_db=# SELECT age, AVG(points) AS avg_points FROM players ORDER BY age DESC;
- ERROR: column "players.age" must appear in the GROUP BY clause or be used in an aggregate function
- LINE 1: SELECT age, AVG(points) AS avg_points FROM players ORDER BY ...
- ^
- nba_db=# SELECT age, AVG(points) AS avg_points FROM players GROUP BY age ORDER BY age DESC;
- age | avg_points
- -----+----------------------
- 39 | 329.5000000000000000
- 38 | 170.5000000000000000
- 37 | 273.8000000000000000
- 36 | 191.3333333333333333
- 35 | 352.2142857142857143
- 34 | 500.3333333333333333
- 33 | 332.0625000000000000
- 32 | 288.1666666666666667
- 31 | 380.8235294117647059
- 30 | 417.9500000000000000
- 29 | 324.4838709677419355
- 28 | 456.7272727272727273
- 27 | 461.6363636363636364
- 26 | 535.8372093023255814
- 25 | 352.9787234042553191
- 24 | 341.5714285714285714
- 23 | 410.6274509803921569
- 22 | 362.5250000000000000
- 21 | 423.3200000000000000
- 20 | 399.1000000000000000
- 19 | 445.7500000000000000
- (21 rows)
- nba_db=# SELECT age, AVG(points) AS avg_points FROM players GROUP BY age ORDER BY age;
- age | avg_points
- -----+----------------------
- 19 | 445.7500000000000000
- 20 | 399.1000000000000000
- 21 | 423.3200000000000000
- 22 | 362.5250000000000000
- 23 | 410.6274509803921569
- 24 | 341.5714285714285714
- 25 | 352.9787234042553191
- 26 | 535.8372093023255814
- 27 | 461.6363636363636364
- 28 | 456.7272727272727273
- 29 | 324.4838709677419355
- 30 | 417.9500000000000000
- 31 | 380.8235294117647059
- 32 | 288.1666666666666667
- 33 | 332.0625000000000000
- 34 | 500.3333333333333333
- 35 | 352.2142857142857143
- 36 | 191.3333333333333333
- 37 | 273.8000000000000000
- 38 | 170.5000000000000000
- 39 | 329.5000000000000000
- (21 rows)
- nba_db=# SELECT team, COUNT(team) AS num_players FROM players GROUP BY points WHERE AVG(points / games) > 12;
- ERROR: syntax error at or near "WHERE"
- LINE 1: ...team) AS num_players FROM players GROUP BY points WHERE AVG(...
- ^
- nba_db=# SELECT team, COUNT(team) AS num_players FROM players GROUP BY AVG(points / games) WHERE AVG(points / games) > 12;
- ERROR: syntax error at or near "WHERE"
- LINE 1: ...players FROM players GROUP BY AVG(points / games) WHERE AVG(...
- ^
- nba_db=# SELECT team, SUM(team) AS num_players FROM players;
- ERROR: function sum(character varying) does not exist
- LINE 1: SELECT team, SUM(team) AS num_players FROM players;
- ^
- HINT: No function matches the given name and argument types. You might need to add explicit type casts.
- nba_db=# SELECT * FROM players
- nba_db-# ;
- id | name | age | team | games | points
- -----+---------------------+-----+------+-------+--------
- 1 | Jeff Adrien | 25 | HOU | 8 | 21
- 2 | Arron Afflalo | 26 | DEN | 62 | 943
- 3 | Blake Ahearn | 27 | UTA | 4 | 10
- 4 | Solomon Alabi | 23 | TOR | 14 | 33
- 5 | Cole Aldrich | 23 | OKC | 26 | 57
- 6 | LaMarcus Aldridge | 26 | POR | 55 | 1191
- 7 | Lavoy Allen | 22 | PHI | 41 | 169
- 8 | Ray Allen | 36 | BOS | 46 | 655
- 9 | Tony Allen | 30 | MEM | 58 | 568
- 10 | Morris Almond | 26 | WAS | 4 | 14
- 11 | Al-Farouq Aminu | 21 | NOH | 66 | 399
- 12 | Louis Amundson | 29 | IND | 60 | 213
- 13 | Chris Andersen | 33 | DEN | 32 | 168
- 14 | Alan Anderson | 29 | TOR | 17 | 163
- 15 | James Anderson | 22 | SAS | 51 | 190
- 16 | Ryan Anderson | 23 | ORL | 61 | 980
- 17 | Carmelo Anthony | 27 | NYK | 55 | 1245
- 18 | Joel Anthony | 29 | MIA | 64 | 219
- 19 | Gilbert Arenas | 30 | MEM | 17 | 72
- 20 | Trevor Ariza | 26 | NOH | 41 | 444
- 21 | Omer Asik | 25 | CHI | 66 | 205
- 22 | D.J. Augustin | 24 | CHA | 48 | 532
- 23 | Gustavo Ayon | 26 | NOH | 54 | 319
- 24 | Kelenna Azubuike | 28 | DAL | 3 | 7
- 25 | Luke Babbitt | 22 | POR | 40 | 202
- 26 | Renaldo Balkman | 27 | NYK | 14 | 42
- 27 | Leandro Barbosa | 29 | TOR | 42 | 512
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players;
- ERROR: column "players.team" must appear in the GROUP BY clause or be used in an aggregate function
- LINE 1: SELECT team, COUNT(name) AS num_players FROM players;
- ^
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players GROUP BY COUNT(name);
- ERROR: aggregate functions are not allowed in GROUP BY
- LINE 1: ... COUNT(name) AS num_players FROM players GROUP BY COUNT(name...
- ^
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players GROUP BY num_players;
- ERROR: aggregate functions are not allowed in GROUP BY
- LINE 1: SELECT team, COUNT(name) AS num_players FROM players GROUP B...
- ^
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players GROUP BY team;
- team | num_players
- ------+-------------
- TOR | 16
- ATL | 15
- POR | 15
- GSW | 18
- MIN | 15
- DET | 14
- IND | 14
- CHI | 14
- UTA | 14
- PHI | 15
- CLE | 20
- DAL | 16
- SAC | 14
- WAS | 19
- DEN | 16
- LAC | 17
- OKC | 15
- SAS | 19
- MEM | 16
- MIL | 15
- LAL | 14
- NJN | 20
- CHA | 16
- PHO | 13
- NOH | 19
- MIA | 15
- ORL | 15
- HOU | 17
- BOS | 15
- NYK | 17
- (30 rows)
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players GROUP BY team ORDER_BY num_players;
- ERROR: syntax error at or near "ORDER_BY"
- LINE 1: ...T(name) AS num_players FROM players GROUP BY team ORDER_BY n...
- ^
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players GROUP BY team ORDER BY num_players;
- team | num_players
- ------+-------------
- PHO | 13
- LAL | 14
- DET | 14
- IND | 14
- CHI | 14
- UTA | 14
- SAC | 14
- POR | 15
- MIL | 15
- MIN | 15
- OKC | 15
- MIA | 15
- PHI | 15
- ORL | 15
- BOS | 15
- ATL | 15
- DEN | 16
- DAL | 16
- CHA | 16
- MEM | 16
- TOR | 16
- NYK | 17
- LAC | 17
- HOU | 17
- GSW | 18
- NOH | 19
- SAS | 19
- WAS | 19
- CLE | 20
- NJN | 20
- (30 rows)
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players GROUP BY team WHERE points / games > 12 ORDER BY num_players DESC;
- ERROR: syntax error at or near "WHERE"
- LINE 1: ...T(name) AS num_players FROM players GROUP BY team WHERE poin...
- ^
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players WHERE points / games > 12 GROUP BY team ORDER BY num_players DESC;
- team | num_players
- ------+-------------
- DEN | 5
- POR | 5
- LAC | 4
- NYK | 3
- GSW | 3
- CHI | 3
- SAC | 3
- WAS | 3
- OKC | 3
- MIL | 3
- LAL | 3
- NJN | 3
- NOH | 3
- MIA | 3
- HOU | 3
- BOS | 3
- ATL | 2
- SAS | 2
- MEM | 2
- DET | 2
- MIN | 2
- CHA | 2
- UTA | 2
- PHI | 2
- CLE | 2
- DAL | 2
- ORL | 2
- TOR | 2
- IND | 1
- PHO | 1
- (30 rows)
- nba_db=# SELECT team, COUNT(name) AS num_players, points / games AS avg_points_per_game FROM players WHERE points / games > 12 GROUP BY team ORDER BY num_players DESC;
- ERROR: column "players.points" must appear in the GROUP BY clause or be used in an aggregate function
- LINE 1: SELECT team, COUNT(name) AS num_players, points / games AS a...
- ^
- nba_db=# SELECT team, COUNT(name) AS num_players, AVG( points,games) AS avg_points_per_game FROM players WHERE points / games > 12 GROUP BY team ORDER BY num_players DESC;
- ERROR: function avg(integer, integer) does not exist
- LINE 1: SELECT team, COUNT(name) AS num_players, AVG( points,games) ...
- ^
- HINT: No function matches the given name and argument types. You might need to add explicit type casts.
- nba_db=# SELECT team, COUNT(name) AS num_players FROM players WHERE points / games > 12 GROUP BY team ORDER BY num_players DESC;
- team | num_players
- ------+-------------
- DEN | 5
- POR | 5
- LAC | 4
- NYK | 3
- GSW | 3
- CHI | 3
- SAC | 3
- WAS | 3
- OKC | 3
- MIL | 3
- LAL | 3
- NJN | 3
- NOH | 3
- MIA | 3
- HOU | 3
- BOS | 3
- ATL | 2
- SAS | 2
- MEM | 2
- DET | 2
- MIN | 2
- CHA | 2
- UTA | 2
- PHI | 2
- CLE | 2
- DAL | 2
- ORL | 2
- nba_db=# SELECT name, points FROM players ORDER BY points / games DESC LIMIT 20;
- name | points
- -------------------+--------
- Kevin Durant | 1850
- LeBron James | 1683
- Kobe Bryant | 1616
- Kevin Love | 1432
- Russell Westbrook | 1558
- Dwyane Wade | 1082
- Carmelo Anthony | 1245
- LaMarcus Aldridge | 1191
- Monta Ellis | 811
- Dirk Nowitzki | 1342
- Derrick Rose | 852
- David Lee | 1147
- Dwight Howard | 1113
- Blake Griffin | 1368
- Deron Williams | 1154
- Eric Gordon | 185
- Andrea Bargnani | 603
- Paul Pierce | 1181
- Al Jefferson | 1170
- Brook Lopez | 96
- (20 rows)
- nba_db=# SELECT name, (points / games) AS points_per_game FROM players ORDER BY points / games DESC LIMIT 20;
- name | points_per_game
- -------------------+-----------------
- Kevin Durant | 28
- LeBron James | 27
- Kobe Bryant | 27
- Kevin Love | 26
- Russell Westbrook | 23
- Dwyane Wade | 22
- Carmelo Anthony | 22
- LaMarcus Aldridge | 21
- Monta Ellis | 21
- Dirk Nowitzki | 21
- Derrick Rose | 21
- David Lee | 20
- Dwight Howard | 20
- Blake Griffin | 20
- Deron Williams | 20
- Eric Gordon | 20
- Andrea Bargnani | 19
- Paul Pierce | 19
- Al Jefferson | 19
- Brook Lopez | 19
- (20 rows)
- nba_db=# \q
- ~/dev/ga-wdi/class-work/week-10/nba_stats on hw-mvp [!?]
- $ git add .
- ~/dev/ga-wdi/class-work/week-10/nba_stats on hw-mvp [+]
- $ git commit
- [hw-mvp 9e2b481] Complete HW
- 2 files changed, 46 insertions(+)
- create mode 100644 sql_commands.md
- delete mode 100644 sql_commands.txt
- ~/dev/ga-wdi/class-work/week-10/nba_stats on hw-mvp
- $ git push
- fatal: The current branch hw-mvp has no upstream branch.
- To push the current branch and set the remote as upstream, use
- git push --set-upstream origin hw-mvp
- ~/dev/ga-wdi/class-work/week-10/nba_stats on hw-mvp
- $ git push --set-upstream origin hw-mvp
- Counting objects: 3, done.
- Delta compression using up to 4 threads.
- Compressing objects: 100% (3/3), done.
- Writing objects: 100% (3/3), 862 bytes | 215.00 KiB/s, done.
- Total 3 (delta 1), reused 0 (delta 0)
- remote: Resolving deltas: 100% (1/1), completed with 1 local object.
- To git.generalassemb.ly:tomatohammado/nba_stats.git
- * [new branch] hw-mvp -> hw-mvp
- Branch 'hw-mvp' set up to track remote branch 'hw-mvp' from 'origin'.
- ~/dev/ga-wdi/class-work/week-10/nba_stats on hw-mvp
- $
Add Comment
Please, Sign In to add comment