集計関数¶

CREATE TABLE simple (x INTEGER, y INTEGER);
INSERT INTO simple (x, y) VALUES
    (10, 20),
    (20, 44),
    (30, 70);

SELECT x, y 
    FROM simple
    ORDER BY x,y;

SELECT COS(x)
    FROM simple
    ORDER BY x;

SELECT SUM(x)
    FROM simple;

SELECT COUNT(col1, col2) FROM table1;

CREATE OR REPLACE TABLE test_null_aggregate_functions (x INT, y INT);
INSERT INTO test_null_aggregate_functions (x, y) VALUES
  (1, 2),         -- No NULLs.
  (3, NULL),      -- One but not all columns are NULL.
  (NULL, 6),      -- One but not all columns are NULL.
  (NULL, NULL);   -- All columns are NULL.

SELECT COUNT(x, y) FROM test_null_aggregate_functions;

SELECT SUM(x + y) FROM test_null_aggregate_functions;

SELECT x AS X_COL, y AS Y_COL 
  FROM test_null_aggregate_functions 
  GROUP BY x, y;