Count the number of people with each name in the [USA Names public dataset](https://cloud.google.com/bigquery/public-data/usa-names).

count-names.sql

#standardSQL
SELECT
  name,
  name_total,
  SUM(name_total) OVER(ORDER BY name ASC) AS name_cumulative
FROM (
  SELECT
    name,
    SUM(number) AS name_total
  FROM
    `bigquery-public-data.usa_names.usa_1910_2013`
  GROUP BY
    name )
ORDER BY
  name ASC