pastebin 3.0 BETA

view entry

Information

Title:
Re: Untitled Description:
Original description posted at 02:22:34 2007-02-20 by Anonymous:
> None Posted by:
Anonymous Added:
02:37:28 on Tuesday, 20th of February, 2007 Source type:
MySQL Number of lines:
2 Number of hits:
8 Options:
Post change or solution to this entry
Copy URL to clipboard
Copy code to clipboard
Download as file Entry control:
Edit entry
Delete entry Related entries:

"Untitled" by Anonymous
- "Re: Untitled" by Anonymous
- "Re: Untitled" by Anonymous

Comments:
0 (Add / View all) Last 3 comments:
There are no comments for this entry.

Source code

1
2

SELECT wins.TeamNum, wins.TeamAbbrev, wincount AS 'Home Wins', losscount AS 'Home Losses' FROM ( select Team.TeamNum Team.TeamAbbrev, count( Game2.HScore ) as wincount from Game2 INNER JOIN Team ON Team.TeamNum = HTeam where Game2.Season='2002' and Game2.HScore > Game2.AScore group by HTeam as HWins) AS wins INNER JOIN (select Team.TeamNum, Team.TeamAbbrev, count( Game2.HScore ) as losscount from Game2,Team where Game2.Season='2002' and Game2.HScore < Game2.AScore and Team.TeamNum = HTeam group by HTeam as HLosses) AS losses ON losses.TeamNum = wins.TeamNum