title: Writing SQL Query, Separating One Columns Into two columns with filter
body: <p>I am not db administrator and now i am facing a problem with the querying single table.</p>
  
  <p>i got the table as follow</p>
  
  <p>updated</p>
  
  <p><img src="https://i.stack.imgur.com/pXjzC.png" alt="enter image description here"></p>
  
  <p>I wan to make a query to come out like the following picture</p>
  
  <p>updated</p>
  
  <p><img src="https://i.stack.imgur.com/8gX22.png" alt="enter image description here"></p>
  
  <p>How can i do it? quite noob for query thanks.</p>