title: SQL Year over year growth percentage from data same query
body: <p>How do I calculate the percentage difference from 2 different columns, calculated in that same query? Is it even possible?</p>
  
  <p>This is what I have right now:</p>
  
  <pre><code>SELECT 
        Year(OrderDate) AS [Year], 
        Count(OrderID) AS TotalOrders, 
        Sum(Invoice.TotalPrice) AS TotalRevenue
  FROM 
      Invoice 
  INNER JOIN Order
          ON Invoice.InvoiceID = Order.InvoiceID
  GROUP BY Year(OrderDate);
  </code></pre>
  
  <p>Which produces this table</p>
  
  <p><a href="https://i.stack.imgur.com/Uqk6W.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Uqk6W.png" alt="enter image description here"></a></p>
  
  <p>Now I'd like to add one more column with the YoY growth, so even when 2016 comes around, the growth should be there..</p>
  
  <p>EDIT:
  I should clarify that I'd like to have for example next to </p>
  
  <pre><code>2015,5,246.28 -&gt; 346,15942029% ((R2015-R2014) / 2014 * 100)
  </code></pre>