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
...