Skip to content

Instantly share code, notes, and snippets.

View brahn's full-sized avatar

Benjamin Rahn brahn

View GitHub Profile

A tricky left join

Consider the following two queries, one that uses an inner join and one that uses a left join

-- A. Inner join with a where condition

select foo.*, bar.*
from foo
join bar
@brahn
brahn / king-letter-on-sessions.txt
Last active February 8, 2017 07:14
Coretta Scott King on the Nomination of Jeff Sessions, March 13, 1986
Original: https://www.scribd.com/document/338729117/Scott-King-1986-Letter-and-Testimony-Signed
March 19, 1986
The Honorable Strom Thurmond, Chairman
Committee on the Judiciary
United States Senate
SD-224 Dirksen Senate Office Building
Washington, D.C. 20510
Re: Nomination of Jefferson B. Sessions
@brahn
brahn / foo.md
Last active December 15, 2015 14:59

tiller-reports

Setting up tiller reports

[...]

Running tiller locally

  1. If necessary, open up an ssh tunnel to the data sources of interest.
@brahn
brahn / google_bubblechart_custom_tooltip.html
Created February 27, 2013 20:32
Attempting to add a custom tooltip to a bubble chart
<html>
<head>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
var drawChart = function () {
var chart = new google.visualization.BubbleChart(document.getElementById('chart_div'));
var table = new google.visualization.DataTable();
table.addColumn('string', 'ID');