output.sql

SQLite version 3.8.9 2015-04-08 12:16:33
Enter ".help" for usage hints.
sqlite> 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;
1|1|123456|2015-05-27 17:00:00.000000
2|2|654321|2015-05-27 17:00:00.000000
sqlite>