All pastes #237048 Raw Edit

Stuff

public text v1 · immutable
·published 2006-11-04 08:45 UTC
rendered paste body
i need to run 1 query that adds 2 queries together
select id, sum(score) as stotal from songs group by id;
select id, sum(score) as stotal from artists group by id;
this 2.. i need to add
i need a third query that would add result of both first queries.
how do i do that under 1 total query?