title: How to query increased column values in a table
body: <p>I've got this problem to find the <strong>Regions where the electorates are growing most quickly</strong> in the table below i.e. finding the largest average percentage of Regions growth rate in 2001, 2005 and 2010 or comparing each region's percentages in 2001, 2005 and 2010.    </p>
  
  <pre class="lang-none prettyprint-override"><code>Region          Electorate  Constituency                ElectionYear
  --------------  ----------  --------------------------  ------------
  South East          109044  Isle of Wight                       2010
  South East          107737  Isle of Wight                       2005
  South East          106305  Isle of Wight                       2001
  North West           90124  Manchester Central                  2010
  London               89601  East Ham                            2010
  London               88624  Croydon North                       2010
  East Midlands        88378  Northampton South                   2005
  London               88236  Brentford and Isleworth             2005
  East Midlands        88058  Daventry                            2005
  South East           88006  Banbury                             2005
  East Midlands        86537  Daventry                            2001
  South West           86324  Devizes                             2005
  London               85943  Ilford South                        2010
  London               85851  Kingston and Surbiton               2010
  East Midlands        85450  Sleaford and North Hykeham          2010
  East Midlands        85271  Northampton South                   2001
  West Midlands        85241  Stratford-on-Avon                   2001
  London               85078  West Ham                            2010
  South West           84821  Bristol West                        2001
  West Midlands        84540  Stratford-on-Avon                   2005
  South East           84379  Banbury                             2010
  London               84049  Brentford and Isleworth             2001
  South East           83935  Winchester                          2005
  London               83904  Harrow East                         2005
  </code></pre>
  
  <p>I tried to look at this by writing this code but I don't think I'm doing the right thing; I think there should be other ways better than this: </p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT DISTINCT Region, Electorate 
  FROM DW_FastGrowingElectorateRegion 
  WHERE Electorate = (SELECT MAX(Electorate) FROM DW_FastGrowingElectorateRegion) 
      OR Electorate = (SELECT MIN(Electorate) FROM DW_FastGrowingElectorateRegion ) 
  GROUP BY Region, Electorate 
  ORDER BY Electorate DESC;
  </code></pre>
  
  <p>The result is this:</p>
  
  <pre><code>Region           Electorate
  South East       109044
  Scotland         31909
  </code></pre>
  
  <p>Any help would be helpful and greatly appreciated as I've spent days trying to sort this. </p>
  
  <p>Thank you.</p>