title: Loop through rows and count based on table name
body: <p>This is my database table:</p>
  
  <pre><code>Status
  ------
  Active
  Active
  Inactive
  Removed
  Removed
  </code></pre>
  
  <p>My desired output:</p>
  
  <pre><code>Status   |  Total  | Percent
  -------------------------------
  Active   |    2    |  33.33   
  Inactive |    1    |  16.66
  Removed  |    3    |  50
  Total    |    6    |  100
  </code></pre>
  
  <p>What i've attempted:</p>
  
  <pre><code>SELECT
      OrderStatus AS Status,
      COUNT(OrderStatus) AS Total,
      ROUND(((COUNT(OrderStatus ) * 100)/COUNT(*)),2) AS Percent
  FROM
      myTable
  </code></pre>
  
  <p>For obvious reasons my query is not working, any help appreciated!</p>