title: How to select Column value as Column name with conditions in SQL table
body: <p>I'm new to SQL. I have a table 'Customers' and it looks like this.</p>
  
  <p><img src="https://i.stack.imgur.com/mFblN.png" alt="enter image description here"></p>
  
  <p>I would like to select 'Gender' AS Gender Column and 'Age' as Age column which would be like this.</p>
  
  <p><img src="https://i.stack.imgur.com/t1H7x.png" alt="enter image description here"></p>
  
  <p>I've tried several ways but it still doesn't show what I need. Please help me.</p>