title: UNION operator to seperate the columns based on the flag value
body: <p>I have table as below.</p>
  
  <pre><code>Name    Primary phone   Primary Ind
  Manju       11              Y
  Manju       22              N
  Tyagi       33              N
  Tyagi       44              Y
  </code></pre>
  
  <p>And I want my result to be displayed like below based on the <code>Primary Ind</code> Flag in my table above. Basically if the primary indicator is "Y" Phone No should go to 'Primary Phone`. IF "N", it should go to "Non Primary" </p>
  
  <pre><code>Name    Primary Phone   Non Primary
  manju        11               22
  Tyagi        44               33
  </code></pre>
  
  <p>I need to achieve this using select and UNION. this is the assignment gave to me. Can somebody help how to do it?</p>