Further reading

• Legacy SQL SELECT statement syntax and options: https://cloud.google.com/bigquery/docs/reference/legacy-sql#select-syntax
• Legacy SQL aggregate functions reference: https://cloud.google.com/bigquery/docs/reference/legacy-sql#aggfunctions
• Standard SQL SELECT statement syntax and options: https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax
• Standard SQL JOINS: https://cloud.google.com/bigquery/docs/reference/standard-sql/query-syntax#join-types
• Standard SQL DML statements: https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax
• Standard SQL functions and operators: https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators