title: How to name rows in SQL
body: <p>I've got the following query:</p>
  <pre><code>(SELECT count(ID)/2 FROM people  where Date between '2000' and '2001') 
  union
  (SELECT count(ID)/3 FROM people where Date between '2002' and '2004') 
  union
  (SELECT count(ID)/6 FROM people where Date between '2005' and '2010')
  </code></pre>
  <p>The numbers are correct. Now I want to give names to the rows to see which people are meant.
  I only know how to give names to columns thus far.</p>
  <p>EDIT: Plus how would I name the column where the new names are in?</p>