1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38

mysql> SELECT max(inmax) FROM (SELECT Utilization.TINmin AS inmin, Utilization.TOUTmin AS outmin, Utilization.TINmax AS inmax, Utilization.TOUTmax AS outmax FROM Utilization WHERE Utilization.sitename = 'Lower Kalskag' AND Utilization.insertdate > STR_TO_DATE('3/1/2010', '%c/%e/%Y') AND Utilization.insertdate < ((STR_TO_DATE('3/31/2010', '%c/%e/%Y') + INTERVAL 1 DAY) - INTERVAL 1 SECOND)) subq;
+------------+
| max(inmax) |
+------------+
| 74997.76   | 
+------------+
1 row in set (0.01 sec)

mysql> SELECT inmax FROM (SELECT Utilization.TINmin AS inmin, Utilization.TOUTmin AS outmin, Utilization.TINmax AS inmax, Utilization.TOUTmax AS outmax FROM Utilization WHERE Utilization.sitename = 'Lower Kalskag' AND Utilization.insertdate > STR_TO_DATE('3/1/2010', '%c/%e/%Y') AND Utilization.insertdate < ((STR_TO_DATE('3/31/2010', '%c/%e/%Y') + INTERVAL 1 DAY) - INTERVAL 1 SECOND)) subq;
+------------+
| inmax      |
+------------+
| 513740.8   | 
| 45926.4    | 
| 1005465.6  | 
| 187944.96  | 
| 0.00       | 
| 32634.88   | 
| 185989.12  | 
| 726056.96  | 
| 49203.2    | 
| 116203.52  | 
| 168867.84  | 
| 0.00       | 
| 0.00       | 
| 64655.36   | 
| 74997.76   | 
| 38635.52   | 
| 122091.52  | 
| 332840.96  | 
| 5806.08    | 
| 113070.08  | 
| 1226833.92 | 
| 155699.2   | 
| 1121976.32 | 
| 1142947.84 | 
+------------+
24 rows in set (0.00 sec)