title: SQL Use of Count and Sum
body: <p>I am trying to formulate an SQL query to both count and sum all of the order totals  in RETAIL_ORDER. Label the count of orders 'Total Number Orders' and the sum or orders 'Total Sales'</p>
  <p>I have the following for a Query but the label for Total number orders is not going to the right place.</p>
  <pre><code>SELECT COUNT(OrderTotal), 
         SUM(OrderTotal) AS 'Total Sales',
         'Total Number Orders' 
  FROM RETAIL_ORDER;
  </code></pre>
  <p><a href="https://i.stack.imgur.com/loeEA.png" rel="nofollow noreferrer">MY Code</a></p>