fhoffa

int sum(int a, int b)
{
  return a + b;
}

fhoffa

Hillary Clinton underperformed the (D) senate candidates

state	name	diff	party	candidates
California	H. Clinton	-2338906	Democratic	K. Harris,L. Sanchez
New York	H. Clinton	-644500	Democratic	C. Schumer
Missouri	H. Clinton	-228333	Democratic	J. Kander
Kentucky	H. Clinton	-184388	Democratic	J. Gray
Washington	H. Clinton	-126365	Democratic	P. Murray

fhoffa

SELECT a.title title, FIRST(b.label) label, SUM(requests) requests
FROM [fh-bigquery:wikipedia.pagecounts_201602] a
JOIN (
  SELECT en_wiki title, en_label label
  FROM [fh-bigquery:public_dump.wikidata_v3] 
  WHERE instance_of.numeric_id=146
) b
ON a.title=b.title
WHERE language='en'
GROUP BY 1

fhoffa

SELECT CORR(a.value, b.value), a.rowid, b.rowid
FROM
(
SELECT column, value, rowid FROM
(
SELECT 'c1' column, c1 AS value, rowid
FROM
(SELECT 1 c1, 2 c2, 3 c3, 'id1' rowid), (SELECT 9 c1, 2 c2, 3 c3, 'id2' rowid), (SELECT 4 c1, 1 c2, 3 c3, 'id3' rowid)
),
(

fhoffa

fhoffa

fhoffa

fhoffa

fhoffa

{
 "metadata": {
  "name": "io sensors correlation plots"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {

fhoffa