title: How to sum alias column table sql
body: <p>I have query sql </p>
  
  <pre><code>select date_format(created_at,'%Y-%m-%d') as date,
  (select count(*)  from tb_media where date_format(created_at,'%Y-%m-%d') = date ) as total
  from tb_media group by date
  </code></pre>
  
  <p>result:</p>
  
  <p><a href="https://i.stack.imgur.com/AYdXL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AYdXL.png" alt="enter image description here"></a></p>
  
  <p>how to sum colomn total??</p>