title: MYSQL - Showing status input as it's own column
body: <p>I'm having trouble writing a SQL query to show the status of a row as it's own column as shown in the picture.</p>
  
  <p><img src="https://i.stack.imgur.com/YBoqT.png" alt="enter image description here"></p>
  
  <p>I was thinking of using an alias for Status as:</p>
  
  <p><code>SELECT 'Table A.Date', 'Table A.Status' as ... FROM Table A;</code></p>
  
  <p>But this doesn't resolve the issue on how to display each status type as their own column and number value.</p>
  
  <p>Can someone point out how to do this?</p>