title: SQL Summary of revenues by region (in ranked order from highest to lowest, calculate % of total for each region)
body: <p>Summary of revenues by region (in ranked order from highest to lowest, calculate % of total for each region). Basically, I am trying to write a query that will show the revenues of each region relative to the total revenue. </p>
  
  <p>I am using SQL in Microsoft Access.</p>
  
  <p>My table has the following columns: ID, Region, Revenue</p>
  
  <p>There are 3 regions: West, Central, East</p>
  
  <p>Heres what I have so far:</p>
  
  <pre><code>SELECT Region, Sum(Revenue) AS TotalRevenue
  FROM Sales 
  GROUP BY Region
  ORDER BY Sum(Revenue) DESC
  </code></pre>
  
  <p>Any help would be greatly appreciated</p>