title: SQL Select from an array
body: <p>Is there an easy way to select from a (long) array?
  I want something like this</p>
  
  <pre><code>SELECT citizenship, count(1) 
  FROM table 
  WHERE year(date) = 2018 
  GROUP BY citizenship
  </code></pre>
  
  <p>But I want all citizenship as column and all dates (from 2000 until as 2018) as rows so I can delete the where clause. </p>