title: How to put three conditions in CASE STATEMENT of SQL?
body: <p>Here is my SQL Query:</p>
  
  <pre><code>SELECT *
  ,CASE WHEN (ETA&gt;10 OR Class='EOL') THEN 'Eligible' ELSE 'Not Applicable' END AS Eligible
  FROM XYZtable
  </code></pre>
  
  <p>The result is:</p>
  
  <pre><code>PN  PD  ETA Class   BU  Serial  Comm    frmToday    Eligible
  CX  CRD 03-10   IP  07  2322    CARD    3   Not Applicable
  BX  CRD 03-18   IP  05  2324    CARD    11  Eligible
  MX  CRD 03-10   EOL 07  2325    CARD    3   Not Applicable
  </code></pre>
  
  <p>I want the below mentioned results in the <code>Eligible</code> Column:</p>
  
  <pre><code>If ETA &gt; 10 THEN 'Eligible'
  If Class = 'EOL' THEN 'Consult Plz'
  Else 'Not Applicable'
  </code></pre>
  
  <p>Thanks.</p>