Tim Sweña (Swast) tswast

I hereby claim:

To claim this, I am signing this object:

	# Copyright 2020 Google LLC
	#
	# Licensed under the Apache License, Version 2.0 (the "License");
	# you may not use this file except in compliance with the License.
	# You may obtain a copy of the License at
	#
	# https://www.apache.org/licenses/LICENSE-2.0
	#
	# Unless required by applicable law or agreed to in writing, software
	# distributed under the License is distributed on an "AS IS" BASIS,

	from google.cloud import bigquery
	import json

	GITHUB_USERNAME = 'crwilcox'
	START_DATE = "2018-03-05"
	END_DATE = "2018-08-31"

	client = bigquery.client.Client()

	query = f"""SELECT repository, type, event AS status, COUNT(*) AS count

	# coding: utf-8

	# Copyright 2018 Google LLC
	#
	# Licensed under the Apache License, Version 2.0 (the "License");
	# you may not use this file except in compliance with the License.
	# You may obtain a copy of the License at
	#
	# https://www.apache.org/licenses/LICENSE-2.0
	#

	#standardSQL
	SELECT
	a.name AS name,
	a.state AS state,
	a.gender AS gender,
	a.year AS year,
	a.number AS number,
	a.name_frequency AS name_frequency
	FROM
	`usa_names.names_conditional_probabilities` a

	#standardSQL
	SELECT
	a.name AS name,
	a.state AS state,
	a.gender AS gender,
	a.year AS year,
	a.number AS number,
	(a.number / b.total_number) AS name_frequency
	FROM
	`bigquery-public-data.usa_names.usa_1910_current` a

	{"rowindex": 0, "repeated_struct_col": [{"nested_struct_col": [{"doubly_nested_array": [1, 2, 3], "doubly_nested_field": "a"}, {"doubly_nested_array": [4, 5, 6], "doubly_nested_field": "b"}]}, {"nested_struct_col": [{"doubly_nested_array": [-1, -2, -3], "doubly_nested_field": "z"}, {"doubly_nested_array": [-4, -5, -6], "doubly_nested_field": "y"}]}]}
	{"rowindex": 1, "repeated_struct_col": [{"nested_struct_col": [{"doubly_nested_array": [10, 20, 30], "doubly_nested_field": "aa"}, {"doubly_nested_array": [40, 50, 60], "doubly_nested_field": "bb"}]}, {"nested_struct_col": [{"doubly_nested_array": [-10, -22, -33], "doubly_nested_field": "zz"}, {"doubly_nested_array": [-44, -55, -66], "doubly_nested_field": "yy"}]}]}

	#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

	#standardSQL
	SELECT
	MAX(max) AS highest_high,
	stn,
	wban
	FROM `bigquery-public-data.noaa_gsod.gsod*`
	WHERE max != 9999.9
	GROUP BY stn, wban
	ORDER BY highest_high DESC

	#standardSql
	SELECT
	group_trips / (single_trips + group_trips) AS percent_groups,
	single_trips + group_trips AS total_trips,
	q.end_station_id AS end_station_id,
	stations.name AS name,
	stations.latitude AS latitude,
	stations.longitude AS longitude
	FROM (
	SELECT

Navigation Menu