title: How to sum group totals in SQL?
body: <p>I need the revenue sum totals of each business which has multiple line items.  Example of the data:</p>
  
  <p><img src="https://i.stack.imgur.com/Dyi7a.gif" alt="enter image description here"></p>
  
  <p>Desired output:<br>
  <img src="https://i.stack.imgur.com/VRZef.gif" alt="enter image description here"></p>
  
  <p>This is what I have  which is not correct:</p>
  
  <pre><code>SELECT  business_name,  sum(revenue)  
  FROM business_table
  GROUP BY  business_name
  </code></pre>