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