title: MYSQL divide results from multiple subqueries with multiple rows
body: <p>I have two queries, the first one generating a table like</p>
  
  <pre><code>SELECT COUNT(channel) AS messages FROM Chats WHERE message LIKE '%word%' GROUP BY UNIX_TIMESTAMP(time) DIV 3600
  +-----+
  | 123 |
  | 127 |
  | 332 |
  | 219 |
  +-----+
  </code></pre>
  
  <p>and the second one</p>
  
  <pre><code>SELECT COUNT(channel) AS messages FROM Chats GROUP BY UNIX_TIMESTAMP(time) DIV 3600
  +-----+
  | 222 |
  | 579 |
  | 590 |
  | 377 |
  +-----+
  </code></pre>
  
  <p>Now I would like to divide all results from the first table by the corresponding value in the second one (results rounded, had to calculate it manually):</p>
  
  <pre><code>+------+
  | 0.55 | #123/222
  | 0.46 | #127/279
  | 0.56 | #332/590
  | 0.58 | #219/377
  +------+
  </code></pre>