| Team Name | Win-Loss Record | Red | Green | Blue | SQL Query | Status |
|---|
| HURRICANES | 21-9 | 226 | 24 | 54 | UPDATE leader_board SET
current_team = 'HURRICANES',
winLossRecord = '21-9',
Abbrev = 'CAR',
Red = 226,
Green = 24,
Blue = 54
WHERE team_rank = 1
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| ISLANDERS | 19-11 | 0 | 39 | 76 | UPDATE leader_board SET
current_team = 'ISLANDERS',
winLossRecord = '19-11',
Abbrev = 'NYI',
Red = 0,
Green = 39,
Blue = 76
WHERE team_rank = 2
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| CAPITALS | 18-10 | 186 | 12 | 47 | UPDATE leader_board SET
current_team = 'CAPITALS',
winLossRecord = '18-10',
Abbrev = 'WSH',
Red = 186,
Green = 12,
Blue = 47
WHERE team_rank = 3
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| LIGHTNING | 18-11 | 0 | 40 | 104 | UPDATE leader_board SET
current_team = 'LIGHTNING',
winLossRecord = '18-11',
Abbrev = 'TB',
Red = 0,
Green = 40,
Blue = 104
WHERE team_rank = 4
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| RED WINGS | 18-12 | | | | UPDATE leader_board SET
current_team = 'R-WINGS',
winLossRecord = '18-12',
Abbrev = 'DET',
Red = 206,
Green = 17,
Blue = 38
WHERE team_rank = 5
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| FLYERS | 16-9 | 247 | 148 | 29 | UPDATE leader_board SET
current_team = 'FLYERS',
winLossRecord = '16-9',
Abbrev = 'PHI',
Red = 247,
Green = 148,
Blue = 29
WHERE team_rank = 6
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| CANADIENS | 17-11 | 175 | 30 | 45 | UPDATE leader_board SET
current_team = 'CANADIENS',
winLossRecord = '17-11',
Abbrev = 'MTL',
Red = 175,
Green = 30,
Blue = 45
WHERE team_rank = 7
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| BRUINS | 19-14 | 255 | 196 | 37 | UPDATE leader_board SET
current_team = 'BRUINS',
winLossRecord = '19-14',
Abbrev = 'BOS',
Red = 255,
Green = 196,
Blue = 37
WHERE team_rank = 8
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| PENGUINS | 14-8 | 252 | 181 | 0 | UPDATE leader_board SET
current_team = 'PENGUINS',
winLossRecord = '14-8',
Abbrev = 'PIT',
Red = 252,
Green = 181,
Blue = 0
WHERE team_rank = 9
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| DEVILS | 18-14 | 206 | 17 | 65 | UPDATE leader_board SET
current_team = 'DEVILS',
winLossRecord = '18-14',
Abbrev = 'NJ',
Red = 206,
Green = 17,
Blue = 65
WHERE team_rank = 10
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| RANGERS | 16-13 | 0 | 56 | 168 | UPDATE leader_board SET
current_team = 'RANGERS',
winLossRecord = '16-13',
Abbrev = 'NYR',
Red = 0,
Green = 56,
Blue = 168
WHERE team_rank = 11
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| PANTHERS | 16-13 | 4 | 30 | 66 | UPDATE leader_board SET
current_team = 'PANTHERS',
winLossRecord = '16-13',
Abbrev = 'FLA',
Red = 4,
Green = 30,
Blue = 66
WHERE team_rank = 12
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| MAPLE LEAFS | 14-12 | | | | UPDATE leader_board SET
current_team = 'LEAFS',
winLossRecord = '14-12',
Abbrev = 'TOR',
Red = 0,
Green = 45,
Blue = 114
WHERE team_rank = 13
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| SENATORS | 14-13 | 202 | 28 | 41 | UPDATE leader_board SET
current_team = 'SENATORS',
winLossRecord = '14-13',
Abbrev = 'OTT',
Red = 202,
Green = 28,
Blue = 41
WHERE team_rank = 14
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| SABRES | 14-14 | 0 | 39 | 76 | UPDATE leader_board SET
current_team = 'SABRES',
winLossRecord = '14-14',
Abbrev = 'BUF',
Red = 0,
Green = 39,
Blue = 76
WHERE team_rank = 15
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| BLUE JACKETS | 13-13 | | | | UPDATE leader_board SET
current_team = 'B-JACKETS',
winLossRecord = '13-13',
Abbrev = 'CBJ',
Red = 0,
Green = 38,
Blue = 84
WHERE team_rank = 16
AND league = 'NHL'
AND division = 'EASTERN'; | Query executed successfully. |
| AVALANCHE | 23-2 | 111 | 38 | 61 | UPDATE leader_board SET
current_team = 'AVALANCHE',
winLossRecord = '23-2',
Abbrev = 'COL',
Red = 111,
Green = 38,
Blue = 61
WHERE team_rank = 1
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| STARS | 21-7 | 1 | 129 | 118 | UPDATE leader_board SET
current_team = 'STARS',
winLossRecord = '21-7',
Abbrev = 'DAL',
Red = 1,
Green = 129,
Blue = 118
WHERE team_rank = 2
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| WILD | 19-9 | 1 | 71 | 35 | UPDATE leader_board SET
current_team = 'WILD',
winLossRecord = '19-9',
Abbrev = 'MIN',
Red = 1,
Green = 71,
Blue = 35
WHERE team_rank = 3
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| GOLDEN KNIGHTS | 16-6 | | | | UPDATE leader_board SET
current_team = 'G-KNIGHTS',
winLossRecord = '16-6',
Abbrev = 'VGK',
Red = 185,
Green = 151,
Blue = 91
WHERE team_rank = 4
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| DUCKS | 19-12 | 188 | 189 | 193 | UPDATE leader_board SET
current_team = 'DUCKS',
winLossRecord = '19-12',
Abbrev = 'ANA',
Red = 188,
Green = 189,
Blue = 193
WHERE team_rank = 5
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| KINGS | 14-8 | 0 | 0 | 0 | UPDATE leader_board SET
current_team = 'KINGS',
winLossRecord = '14-8',
Abbrev = 'LA',
Red = 0,
Green = 0,
Blue = 0
WHERE team_rank = 6
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| OILERS | 15-12 | 4 | 30 | 66 | UPDATE leader_board SET
current_team = 'OILERS',
winLossRecord = '15-12',
Abbrev = 'EDM',
Red = 4,
Green = 30,
Blue = 66
WHERE team_rank = 7
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| SHARKS | 16-14 | 3 | 114 | 133 | UPDATE leader_board SET
current_team = 'SHARKS',
winLossRecord = '16-14',
Abbrev = 'SJ',
Red = 3,
Green = 114,
Blue = 133
WHERE team_rank = 8
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
Missing colors for team: MAMMOTH
| Query not generated for team: MAMMOTH |
| BLACKHAWKS | 13-13 | | | | UPDATE leader_board SET
current_team = 'B-HAWKS',
winLossRecord = '13-13',
Abbrev = 'CHI',
Red = 206,
Green = 17,
Blue = 65
WHERE team_rank = 10
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| JETS | 15-15 | 5 | 51 | 115 | UPDATE leader_board SET
current_team = 'JETS',
winLossRecord = '15-15',
Abbrev = 'WPG',
Red = 5,
Green = 51,
Blue = 115
WHERE team_rank = 11
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| BLUES | 12-14 | 0 | 47 | 108 | UPDATE leader_board SET
current_team = 'BLUES',
winLossRecord = '12-14',
Abbrev = 'STL',
Red = 0,
Green = 47,
Blue = 108
WHERE team_rank = 12
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| KRAKEN | 12-12 | 153 | 217 | 217 | UPDATE leader_board SET
current_team = 'KRAKEN',
winLossRecord = '12-12',
Abbrev = 'SEA',
Red = 153,
Green = 217,
Blue = 217
WHERE team_rank = 13
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| FLAMES | 13-16 | 207 | 10 | 44 | UPDATE leader_board SET
current_team = 'FLAMES',
winLossRecord = '13-16',
Abbrev = 'CGY',
Red = 207,
Green = 10,
Blue = 44
WHERE team_rank = 14
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| PREDATORS | 12-15 | 255 | 184 | 28 | UPDATE leader_board SET
current_team = 'PREDATORS',
winLossRecord = '12-15',
Abbrev = 'NSH',
Red = 255,
Green = 184,
Blue = 28
WHERE team_rank = 15
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |
| CANUCKS | 12-17 | 0 | 32 | 91 | UPDATE leader_board SET
current_team = 'CANUCKS',
winLossRecord = '12-17',
Abbrev = 'VAN',
Red = 0,
Green = 32,
Blue = 91
WHERE team_rank = 16
AND league = 'NHL'
AND division = 'WESTERN'; | Query executed successfully. |