diff options
| author |  Adam Chlipala <adamc@hcoop.net> | 2008-08-28 12:56:08 -0400 |
|---|---|---|
| committer | Adam Chlipala <adamc@hcoop.net> | 2008-08-28 12:56:08 -0400 |
| commit | 86b1f463ce9af2ddfcd86bb75279b9809b22db6a (patch) | |
| tree | b356ee03cb6af9e37de926271f5cc02376641fc9 /tests | |
| parent | fe8bd11ade81a5835d72c498a763c13c17fddd25 (diff) | |
More aggregate functions
Diffstat (limited to 'tests')
| -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) |