sql

Sql code posted by foo
created at 14 May 12:47, updated at 20 May 01:50

Edit | Back 
1
2
3
4
5
6
7
8
9
 
SELECT wpdat.workpoolid,
     max(wpdat.open) AS open_high,
     min(wpdat.open) AS open_low,
     max(wpdat.resubmissions) AS resubmissions_high,
     min(wpdat.resubmissions) AS resubmissions_low
FROM workpool AS wpdat
WHERE wpdat.`timestamp` >= (unix_timestamp()
              - 60 * 60 * 24 * 7+60*60)
GROUP BY wpdat.workpoolid
328 Bytes in 5 ms with coderay