1 echo SELECT f1, f2, SUM(f3) FROM t1 GROUP BY f1, f2 ORDER BY f1;
2 SELECT f1, f2, SUM(f3) FROM t1 GROUP BY f1, f2 ORDER BY f1;
3 echo SELECT f1, f2, SUM(f3), COUNT(f4) FROM t1 GROUP BY f1, f2 ORDER BY f1, f2;
4 SELECT f1, f2, SUM(f3), COUNT(f4) FROM t1 GROUP BY f1, f2 ORDER BY f1, f2;
5 echo SELECT f1, SUM(f3), MIN(f2), MAX(f4) FROM t1 GROUP BY f1 ORDER BY f1;
6 SELECT f1, SUM(f3), MIN(f2), MAX(f4) FROM t1 GROUP BY f1 ORDER BY f1;
7 echo SELECT f1, SUM(f3), MIN(f2), MAX(f4) FROM t1 GROUP BY f1 HAVING SUM(f3) <= 5.5 ORDER BY f1;
8 SELECT f1, SUM(f3), MIN(f2), MAX(f4) FROM t1 GROUP BY f1 HAVING SUM(f3) <= 5.5 ORDER BY f1;