query question - Please help

[Anon]

select avg(score) as scoreave, sum(score) as scoresum, sum(size) as sizesum, count(ruler) as planet_tot from universe where alliance like '%bleh%'

How do I make the above query perform the same tasks but grab all the different alliances in the alliance field? I need to do the like rather than = as well because I want the results grouped by alliance but i need to be able to match partial not exact.

thanks for your time.

-Michael

[Anon]

What database are you using? If it supports subselect, then you could use a subselect to do it. If not, then you'll likely have to select alliance group by alliance then loop through the results one at a time.

[Anon]

did you try a GROUP BY clause? something like this:

select a.alliance, avg(a.score) as scoreave, sum(a.score) as scoresum, sum(a.size) as sizesum, count(a.ruler) as planet_tot
from universe a
where a.alliance like '%bleh%'
group by a.alliance

[Anon]

Arthur Drury wrote:

did you try a GROUP BY clause? something like this:

select a.alliance, avg(a.score) as scoreave, sum(a.score) as scoresum, sum(a.size) as sizesum, count(a.ruler) as planet_tot
from universe a
where a.alliance like '%bleh%'
group by a.alliance

Thats just it, I want to loose the %bleh% from the select statement because I want it to go through everything in the alliance column