title: how to add values from select statement as a new column
body: <p>i have my table as</p>
  <pre><code>ID  FirstName   LastName    ReportsTo       Position    Age
  8   Ashley      Johnson     null            Intern      25  
  5   Noah        Fritz       Jenny Richards  Assistant   30  
  6   David       S           Jenny Richards  Director    32  
  3   Jenny       Richards    null            CEO         45  
  </code></pre>
  <p>i want to add a column as &quot;Boss title&quot; to above table with values from below select statement. but it is not working.</p>
  <pre><code>SELECT *,
      case when ReportsTo='Jenny Richards' then 'CEO'
      else 'None' end 
      as 'Boss Title'
      FROM maintable_L8MOQ where ReportsTo='Jenny Richards' or ReportsTo is null order by age;
  </code></pre>