title: MySQL SUM of the total COUNT
body: <pre><code>Seat Type   Quantity left
  
  
  Business        23
  Economy         27
  First           15
  
              Total quantity left : ?
  </code></pre>
  
  <p>DBMS = MySQL</p>
  
  <p>I've tried the following SQL which to print the above information</p>
  
  <pre><code>$sql = "SELECT SeatType, COUNT(SeatType)AS quantity
                FROM  seat
  
                WHERE SeatAvailable = 'Yes'  
                GROUP BY SeatType
                ";
  </code></pre>
  
  <p>How can i sum up the total quantity left(eg:23+27+25) ?
  Thx for the help in advanced...</p>