sum query 1

[gearypa]

Hi
I have a table set up in my database called "teams" which stores 'team_name' and 'points_scored'. I want to be able to select 10 teams from the table and sum their points together giving an overall total. For example, I want to get the total points amassed by Arsenal,Liverpool,Manchester United,Newcastle,Celtic,Chelsea,Portsmouth, Watford,Livinston,Southampton. I would be very grateful for any help you could give me

Thanks
Patrick

 

[swampBoogie]

select sum(points_scored)
from teams
where team_name in 
('Arsenal','Liverpool','Manchester United',
'Newcastle','Celtic','Chelsea','Portsmouth',
'Watford','Livinston','Southampton')