Skip to content

Instantly share code, notes, and snippets.

@jmxpearson

jmxpearson/ethojoin.sql

Last active December 28, 2015 17:19
Show Gist options
  • Save jmxpearson/7535181 to your computer and use it in GitHub Desktop.
Save jmxpearson/7535181 to your computer and use it in GitHub Desktop.
Download ZIP
Sample join command to get spike info for Geoff's data
Raw
ethojoin.sql
select count(*), var, unit, sum(start - stop)
from (
select movie, montime, mofftime
from (spikes, showings
where spikes.time > ontime and spikes.time < offtime)
join etho on movie )
group by etho.var, unit
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment