title: How to group by sum without using sum function in select?
body: <p>There's a customer table having id, firstname,  country and invoice total( for each customer). I need to write a query displaying list of countries (in descending order) according to revenue generated by each country. 
   <img src="https://i.stack.imgur.com/yTzO1.png" alt=" expected result ">
   I'm trying the following  the following query: </p>
  
  <p>Select country, sum(invoicetotal)  from customer group by country order by 2 desc</p>
  
  <p><img src="https://i.stack.imgur.com/9aqZf.png" alt="result of above query"></p>
  
  <p>The output is according to the expected result but with an additional column of sum(invoicetotal).  I cannot figure a way to order the countries according to the sum of their imvoicetotal without using sum()  function in select. </p>