title: Create one table/view with two different columns from the same source
body: <p>I have a table with a column which contains odd and even numbers (ex. 1, 2, 3, 4, 5 etc).</p>
  <p>I have to create an output table or view with two columns, odd_numbers and even_numbers, like this:</p>
  <pre><code>odd_numbers   even_numbers
  1             2
  3             4
  5             6
  </code></pre>
  <p>How do I do that? The condition is easy (where mod (num,2) = 0 or &lt;&gt; 0) but how do I populate the view?
  I can't figure it out.</p>