title: Can if-then-else logic be done in Redshift?
body: <p>I am a newbie to <code>RedShift</code> but experienced with <code>MSSQL</code>. I was wondering if there's any way to write an if-then-else logic in <code>Redshift</code>?</p>
  
  <p>Basically I want to run this logic in <code>Redshift</code>:</p>
  
  <pre><code>if ((select count(*) from a) - (select count(*) from b)) = 0 then 
     drop table a;
  </code></pre>
  
  <p>Thanks in advance!</p>