How to Use Standard SQL Dialect

You can specify the SQL variant, either legacy SQL or standard SQL, by adding a prefix to your code, for example:

#standardSQL
SELECT
  weight_pounds, state, year, gestation_weeks
FROM
 `bigquery-public-data.samples.natality`
ORDER BY weight_pounds DESC
LIMIT 10;