Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

where did you sleep MS?

By: a guest on May 7th, 2011  |  syntax: MySQL  |  size: 0.34 KB  |  hits: 65  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. -- where did you sleep MS?
  2. SELECT
  3. MIN(start) AS bedtime,
  4. MAX(start) AS wakeup,
  5. ROUND(MAX(start)-MIN(start)) AS duration,
  6. X(loc) AS lat,
  7. Y(loc) AS lon
  8. FROM ms
  9. WHERE
  10.     start > 0
  11. AND locid >0
  12. GROUP BY locid
  13. HAVING duration > 760000
  14. AND HOUR(bedtime) BETWEEN 22 AND 23
  15. AND HOUR(wakeup) BETWEEN 6 AND 10
  16. ORDER BY start;
create a new version of this paste RAW Paste Data