title: SUM after COUNT and Group By MYSQL
body: <p>I want to ask about SQL in mysql. Im stack over 1 hour :( <br>
  I have sql : </p>
  
  <pre><code>    SELECT TZL.IsMissed, COUNT(TZL.ChatID) as Amount FROM tblLog TZL group by TZL.IsMissed
  </code></pre>
  
  <p>And the result :</p>
  
  <pre><code>| IsMissed | Amount |
  |        0 |    100 |
  |        1 |    500 |
  </code></pre>
  
  <p>I want add one more column after Amount column, let say the name of new column is <strong>SumAmount</strong>.<br> i want <strong>SumAmount</strong> value is <strong>SUM</strong> of the Amount Column. </p>
  
  <p>| IsMissed | Amount | SumAmount | <br>
  | 0 | 100 | 600 | <br>
  | 1 | 500 | 600 | <br></p>
  
  <p>I already try sql like below : </p>
  
  <pre><code>SELECT
      tbl.*,SUM(tbl.Amount) as SumAmount
  FROM
      (
          SELECT
              TZL.IsMissed,
              COUNT(TZL.ChatID) AS Amount
          FROM
              tblLog TZL
          GROUP BY
              TZL.IsMissed
      ) tbl
  GROUP BY
  tbl.IsMissed 
  WITH ROLLUP
  </code></pre>
  
  <p>But with <strong>ROLLUP</strong> the result is add a new one row, not column. Anyone can teach me for this ? 
  Thanks for answer </p>