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

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

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