title: Excluding 'Nulls' from alias column
body: <p>hoping you guys can help me out. Am a trainee analyst so need a hand. Please see below query:</p>
  
  <pre><code>SELECT [PATHWAY_ID], [PAS_ID], [Patient_Name], [Pathway_Specialty], [Clinician],
         [Referral_priority], [RTT_START_DTTM], [Days Waiting], [Activity Type],
         [Last Activity Type], [Next_Appt_DTTM], [First_Appointment_Flag],
         CASE WHEN [Days Waiting] &lt;=97 AND [Next_Appt_DTTM] IS NOT NULL THEN 'Booked'
              WHEN [Days Waiting] &gt;=98 AND [Next_Appt_DTTM] IS NULL THEN 'Unbooked'
         END AS 'Booked Status'
  FROM [GWH_RTT].[rtt].[GWH_RTT_Nonadmitted_PTL]
  WHERE [Referral_priority] = 'Routine'
  ORDER BY 'Booked Status' DESC
  </code></pre>
  
  <p>In my alias column I have Nulls in there that don't match my case statement. How do I ask SQL to return my case statement excluding the Nulls in my alias column?</p>