title: SQL Case Basics
body: <p>I'm just new in this SQL world I just wonder if you have this logic</p>
  
  <p><strong>If NAME is JOHN and if ID is JOHN A then JOHN 2</strong></p>
  
  <p><strong>If ID is JOHN A then JOHN 1</strong></p>
  
  <p>I'm Trying to figure out if the SQL code to make this work is</p>
  
  <p><em>Case
  When "ID" is 'JOHN A' then 'JOHN B'</em></p>
  
  <p><em>When "ID" is 'JOHN A' then 'JOHN 2" when "NAME" is 'JOHN'
  End</em></p>
  
  <p>Is any of those correct?
  Any better SQL in Case basis?
  Help would be very much appreciated</p>