Re: [sqlite] Help on forming the correct aggregation statement with a Union clause

On Mon, 19 May 2014 21:58:58 -0500 Wendy wrote: > I'm still not getting the results I need for this query: anyone with > any idea, help greatly appreciated. > > "SELECT AwayTeam As 'Team', CASE WHEN (AwayTeamScore > HomeTeamScore) > THEN 3 WHEN (AwayTeamScore=HomeTeamScore)

Re: [sqlite] Help on forming the correct aggregation statement with a Union clause

Hi, I'm still not getting the results I need for this query: anyone with any idea, help greatly appreciated. "SELECT AwayTeam As 'Team', CASE WHEN (AwayTeamScore > HomeTeamScore) THEN 3 WHEN (AwayTeamScore=HomeTeamScore) THEN 1 ELSE 0 END AS 'Points' FROM Results UNION ALL SELECT HomeTeam As

Re: [sqlite] Help on forming the correct aggregation statement with a Union clause

Op 15 mei 2014, om 12:09 heeft E.Pasma het volgende geschreven: Op 14 mei 2014, om 21:44 heeft Wendy het volgende geschreven: Hi, Wondering if anyone can help me with the following: - Does anyone know how I can get the SUM() aggregate function within this SQLite statement? SELECT

Re: [sqlite] Help on forming the correct aggregation statement with a Union clause

Op 14 mei 2014, om 21:44 heeft Wendy het volgende geschreven: Hi, Wondering if anyone can help me with the following: - Does anyone know how I can get the SUM() aggregate function within this SQLite statement? SELECT AwayTeam As 'Team', CASE WHEN AwayTeamScore > HomeTeamScore

[sqlite] Help on forming the correct aggregation statement with a Union clause

Hi, Wondering if anyone can help me with the following: - Does anyone know how I can get the SUM() aggregate function within this SQLite statement? SELECT AwayTeam As 'Team', CASE WHEN AwayTeamScore > HomeTeamScore THEN 3 WHEN AwayTeamScore=HomeTeamScore THEN 1 ELSE 0 END AS