Skip to content

Instantly share code, notes, and snippets.

@daynebatten
Created March 20, 2015 11:47
Show Gist options
  • Select an option

  • Save daynebatten/1dcf3d81455d9bc9ff90 to your computer and use it in GitHub Desktop.

Select an option

Save daynebatten/1dcf3d81455d9bc9ff90 to your computer and use it in GitHub Desktop.
create temp table
fullvoters
as select
*,
random() as split
from
voters
where
len(first_name) > 1
and len(middle_name) > 1
and gender in ('M', 'F');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment