Appendix / Advanced Report Usage Notes |
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) ...
CREATE TABLE $FINAL_RESULT_TABLE SELECT fts.contact , COUNT(*) AS session_count , SUM(fts.bytes_transferred) AS total_bytes_transferred ...