SQL Server sum multiple columns and group

Question

I would like to in SQL Server to sum values from two different columns and grouping by team, but I'm not getting too much success.

Here's an example of the data:

And on the above image, how i would like it to be summed.

Here's the code I've written so far:

Select
    Fut.HomeTeam As Equipa,
    Sum(Fut.FTHG) As Golos
From 
    Database Fut
Group By 
    Fut.HomeTeam

Union All

Select
    Fut.AwayTeam As Equipa,
    Sum(Fut.FTAG) As Golos
From 
    Database Fut
Group By 
    Fut.AwayTeam
Order By 
    Golos Desc

Do FTHG and FTAG have anything to do with this calculation? They are not very meaningful. — Gordon Linoff
– Gordon Linoff, Commented Mar 18, 2017 at 20:17

SqlZim · Accepted Answer · 2017-03-18 20:22:01Z

2

You were pretty close, I think this is what you want:

select 
    Equipa
  , sum(Golos) as Golos
from (
  Select
    Fut.HomeTeam As Equipa,
    Fut.FTHG As Golos
  From Database Fut

  Union All
  Select
    Fut.AwayTeam As Equipa,
    Fut.FTAG As Golos
  From Database Fut
) u
Group By Equipa
Order By Sum(Golos) Desc

answered Mar 18, 2017 at 20:22

SqlZim

38.2k6 gold badges45 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Server sum multiple columns and group

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related