diff options
Diffstat (limited to 'tests/agg.lac')
| -rw-r--r-- | tests/agg.lac | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/tests/agg.lac b/tests/agg.lac index 7061612b..f9b744e9 100644 --- a/tests/agg.lac +++ b/tests/agg.lac @@ -1,4 +1,7 @@ table t1 : {A : int, B : string, C : float} table t2 : {A : float, D : int} -val q1 = (SELECT COUNT( * ) AS N FROM t1) +val q1 = (SELECT COUNT( * ) AS X FROM t1) +val q2 = (SELECT AVG(t1.A) AS X FROM t1) +val q3 = (SELECT SUM(t1.C) AS X FROM t1) +val q4 = (SELECT MIN(t1.B) AS X, MAX(t1.A) AS Y FROM t1) |