title: SQL group and summing at new row
body: <p>I have an issue where I am trying to create a new &quot;row&quot; (not part of the database) where it only gives me the SUM of the &quot;count&quot; column. I am wondering if that is possible?</p>
  <p>I tried adding the SUM(count(cost) as &quot;total product cost&quot; OVER() AS Total_Count; but that just creates a new column with the summed amount of 550.00 displayed in each row. I want that 550.00 to be at the bottom as the final count of that column.</p>
  <pre><code>select product, count(cost) as 'total product cost'
  
  from product_Table
  
  where product_Tier = 'grocery'
  
  and as_of_date = '8/13/2020'
  
  Group By product
  
  Results:
  
  product   total product cost
  corn       250.00
  tomatoes   300.00
  SUM        550.00          &lt;--trying to create a row like this.
  
  </code></pre>