title: When I create VIEW there is a wrong result, while simple SQL query gives a correct result
body: <p>This is how I define a rule for my VIEW:</p>
  <pre><code>SELECT `yearByWeek`, `week`, ( SELECT MIN(dolphin_day.date) ) AS 'start', ( SELECT SUM(dolphin_day.countHour)) AS 'countHours'
  
  FROM `dolphin_day`
  GROUP BY `yearByWeek`, `week`
  ORDER BY `yearByWeek` DESC, `week` DESC
  </code></pre>
  <p>❌ wrong result for VIEW is the following:</p>
  <p><a href="https://i.stack.imgur.com/xWn0z.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xWn0z.png" alt="enter image description here" /></a></p>
  <p>✅ correct result for SQL query:</p>
  <p><a href="https://i.stack.imgur.com/GnWGg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/GnWGg.png" alt="enter image description here" /></a></p>
  <p>Why result for view is totally wrong?</p>