Member Avatar for abzy1991

Using SQL I have to SUM the total of each game but I can only select the games that have more than 10 scores in total .
So select GameNo,sum(goals) from tblGame, tblAthlete.

But I'm stuck on the 'where' bit.....select GameNO where (sum(goals)>=10);
So not only do I have to calculate the goals for each games, But I can only select the games that have more than 10 scores
Any suggestions for this query?
Below, I have given a little example.

I want to only list the games that have more than 10 scores,if you look below the answer is **Game2 & Game3 **
so in game1 the total of scoring was 5
game2 the total of scoring was 10
game3 the total of scoring was 12

Games1
Athletes scoring
Athlete 1 = 4 goals
Athlete 2 = 0 goals
Athlete 3 = 0 goals
Athlete 4 = 1 goals

Games2
Atheletes scoring
Athlete 1 = 4 goals
Athlete 2 = 5 goals
Athlete 3 = 0 goals
Athlete 4 = 1 goals

Games3
Athletes scoring
Athlete 1 = 2 goals
Athlete 2 = 4 goals
Athlete 3 = 2 goals
Athlete 4 = 4 goals

So, How would I SUM the total and only select games that only have more than 10 scores in total??
Please help me out here!!! thanks

  • 2 Contributors
  • 2 Replies
  • 165 Views
  • 17 Hours Discussion Span
  • Latest Post Latest Post by abzy1991
Member Avatar for mokong

Hi you must use HAVING to condition an aggregate.

see this:

HAVING SUM(GOAL) >= 10

thanks,
Mokong

Member Avatar for abzy1991

Ohhh, thank you, it works :)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.