The question is simple: I want to do:
SELECT SUM((... a subquery that returns multiple rows with a single int value ...)) AS total;
How would I do that? I get an error saying that subquery returns more than one row. I need to have it in a subquery.