title: How to simplify the query
body: <p>I have a MySQL query. Is there any way to simplify the query? Thanks.</p>
  <pre><code>SELECT `column1`,100*CAST(COUNT(*) AS FLOAT) / (SELECT COUNT(*) FROM `table`) 
  FROM `table`
  GROUP BY `column1
  </code></pre>
  <p>I want to calculate the percentage of each group element in the total entry. I think I duplicate this</p>
  <pre><code>(SELECT COUNT(*) FROM `table`)
  </code></pre>
  <p>Is there any way I could get the total amount of entries without using the SELECT twice?
  I am using Mysql 8.0</p>