Advanced Report Usage Notes: Always Name Your Computed or Aggregated Columns
INCORRECT:
Always name your computed or aggregate columns, and avoid names that might be reserved words. In particular, do not call a final result column "name", "count", "id", and so on.
CREATE TABLE $FINAL_RESULT_TABLE
SELECT
fts.contact
, COUNT(*)
, SUM(fts.bytes_transferred)
...
CORRECT:
CREATE TABLE $FINAL_RESULT_TABLE
SELECT
fts.contact
, COUNT(*) AS session_count
, SUM(fts.bytes_transferred) AS total_bytes_transferred
...