Skip to content

Instantly share code, notes, and snippets.

/query.rb

Created June 1, 2015 16:03
Show Gist options
  • Save anonymous/538ee63c1d0bc7ef533d to your computer and use it in GitHub Desktop.
Save anonymous/538ee63c1d0bc7ef533d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
query.rb
select dream_color_monitors.id,calibrations.dream_color_monitor_id,tag,min(date)
from dream_color_monitors,calibrations
where dream_color_monitors.id = calibrations.dream_color_monitor_id
and date > date('now')-90
group by tag
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment