title: SQL query to get min, max rows
body: <p>I have following sample data, I want to get min and max time of every consecutive status.</p>
  
  <pre><code>cat     subcat  status  logtime
  fruits  apple   0   30-10-2017 06:00
  fruits  apple   0   30-10-2017 06:03
  fruits  apple   0   30-10-2017 06:06
  fruits  apple   0   30-10-2017 06:09
  fruits  apple   0   30-10-2017 06:12
  fruits  apple   0   30-10-2017 06:15
  fruits  apple   0   30-10-2017 06:18
  fruits  apple   0   30-10-2017 06:21
  fruits  apple   0   30-10-2017 06:24
  fruits  apple   0   30-10-2017 06:27
  fruits  apple   0   30-10-2017 06:30
  fruits  apple   0   30-10-2017 06:33
  fruits  apple   0   30-10-2017 06:36
  fruits  apple   0   30-10-2017 06:39
  fruits  apple   0   30-10-2017 06:42
  fruits  apple   0   30-10-2017 06:45
  fruits  apple   0   30-10-2017 06:48
  fruits  apple   0   30-10-2017 06:51
  fruits  apple   0   30-10-2017 06:54
  fruits  apple   0   30-10-2017 06:57
  fruits  strawberry  1   30-10-2017 06:00
  fruits  strawberry  1   30-10-2017 06:03
  fruits  strawberry  1   30-10-2017 06:06
  fruits  strawberry  2   30-10-2017 06:09
  fruits  strawberry  1   30-10-2017 06:12
  fruits  strawberry  1   30-10-2017 06:15
  fruits  strawberry  1   30-10-2017 06:18
  fruits  strawberry  1   30-10-2017 06:21
  fruits  strawberry  1   30-10-2017 06:24
  fruits  strawberry  1   30-10-2017 06:27
  fruits  strawberry  1   30-10-2017 06:30
  fruits  strawberry  1   30-10-2017 06:33
  fruits  strawberry  1   30-10-2017 06:36
  fruits  strawberry  1   30-10-2017 06:39
  fruits  strawberry  2   30-10-2017 06:42
  fruits  strawberry  1   30-10-2017 06:45
  fruits  strawberry  1   30-10-2017 06:48
  fruits  strawberry  1   30-10-2017 06:51
  fruits  strawberry  1   30-10-2017 06:54
  fruits  strawberry  1   30-10-2017 06:57
  fruits  blueberry   0   30-10-2017 06:00
  fruits  blueberry   0   30-10-2017 06:03
  fruits  blueberry   0   30-10-2017 06:06
  fruits  blueberry   2   30-10-2017 06:09
  fruits  blueberry   0   30-10-2017 06:12
  fruits  blueberry   0   30-10-2017 06:15
  fruits  blueberry   0   30-10-2017 06:18
  fruits  blueberry   0   30-10-2017 06:21
  fruits  blueberry   0   30-10-2017 06:24
  fruits  blueberry   0   30-10-2017 06:27
  fruits  blueberry   0   30-10-2017 06:30
  fruits  blueberry   0   30-10-2017 06:33
  fruits  blueberry   0   30-10-2017 06:36
  fruits  blueberry   0   30-10-2017 06:39
  fruits  blueberry   2   30-10-2017 06:42
  fruits  blueberry   0   30-10-2017 06:45
  fruits  blueberry   0   30-10-2017 06:48
  fruits  blueberry   0   30-10-2017 06:51
  fruits  blueberry   0   30-10-2017 06:54
  fruits  blueberry   0   30-10-2017 06:57
  fruits  guaua   1   30-10-2017 06:00
  fruits  guaua   1   30-10-2017 06:03
  fruits  guaua   1   30-10-2017 06:06
  fruits  guaua   2   30-10-2017 06:09
  fruits  guaua   1   30-10-2017 06:12
  fruits  guaua   1   30-10-2017 06:15
  fruits  guaua   1   30-10-2017 06:18
  fruits  guaua   1   30-10-2017 06:21
  fruits  guaua   1   30-10-2017 06:24
  fruits  guaua   1   30-10-2017 06:27
  fruits  guaua   1   30-10-2017 06:30
  fruits  guaua   1   30-10-2017 06:33
  fruits  guaua   1   30-10-2017 06:36
  fruits  guaua   1   30-10-2017 06:39
  fruits  guaua   2   30-10-2017 06:42
  fruits  guaua   1   30-10-2017 06:45
  fruits  guaua   1   30-10-2017 06:48
  fruits  guaua   1   30-10-2017 06:51
  fruits  guaua   1   30-10-2017 06:54
  fruits  guaua   1   30-10-2017 06:57
  </code></pre>
  
  <p>I'm trying get min, max time of each status for cat and subcat status.</p>
  
  <p>Output result should be following: </p>
  
  <pre><code>cat     subcat      status  mintime maxtime
  fruits  apple       0   30-10-2017 06:00    30-10-2017 06:57
  fruits  strawberry  1   30-10-2017 06:00    30-10-2017 06:06
  fruits  strawberry  2   30-10-2017 06:09    30-10-2017 06:09
  fruits  strawberry  1   30-10-2017 06:12    30-10-2017 06:39
  fruits  strawberry  2   30-10-2017 06:42    30-10-2017 06:42
  fruits  strawberry  1   30-10-2017 06:45    30-10-2017 06:57
  fruits  blueberry   0   30-10-2017 06:00    30-10-2017 06:06
  fruits  blueberry   2   30-10-2017 06:09    30-10-2017 06:09
  fruits  blueberry   0   30-10-2017 06:12    30-10-2017 06:39
  fruits  blueberry   2   30-10-2017 06:42    30-10-2017 06:42
  fruits  blueberry   0   30-10-2017 06:45    30-10-2017 06:57
  fruits  guaua       1   30-10-2017 06:00    30-10-2017 06:06
  fruits  guaua       2   30-10-2017 06:09    30-10-2017 06:09
  fruits  guaua       1   30-10-2017 06:12    30-10-2017 06:39
  fruits  guaua       2   30-10-2017 06:42    30-10-2017 06:42
  fruits  guaua       1   30-10-2017 06:45    30-10-2017 06:57
  </code></pre>
  
  <p>tried with following sql query but unable to get above output instead its giving min, max total hour.</p>
  
  <pre><code>SELECT cat,
          subcat,
          status,        
          min(logtime) as minlog,
          max(logtime) as maxlog
  FROM fruits_log
  WHERE 
      cat = 'fruits'
      AND date_format(logtime,'%Y-%m-%d %H) = '2017-10-30 06'
      AND status IN ('0','1','2')
  GROUP BY cat,subcat,date_format(logtime,'%Y-%m-%d %H),status
  ORDER BY cat,subcat,minlog ;
  </code></pre>
  
  <p>Please help what i'm missing in above query</p>