SELECT
  (SELECT aggregate(col1) FROM tbl WHERE condition) AS col1,
                         ...............
  (SELECT aggregate(coln) FROM tbl WHERE condition) AS coln;

SELECT id, aggregate(col1) AS agg_c1 FROM tbl WHERE condition GROUP BY id;,
                        ...............
SELECT id, aggregate(coln) AS agg_cn FROM tbl WHERE condition GROUP BY id;