title: Case for the whole dataset in sql table
body: <p>Have a table like that. Let's pretend it is full table and we dont have any other rows:</p>
  
  <pre><code>ID Place
  1   A
  1   B
  2   C 
  3   D
  </code></pre>
  
  <p>How can I perform such thing:</p>
  
  <pre><code>ID Place YesNo
  1   A      1
  1   B      1
  1   C      0
  1   D      0
  2   A      0 
  2   B      0
  2   C      1
  2   D      0
  3   A      0
  3   B      0
  3   C      0
  3   D      1
  </code></pre>
  
  <p>For yes/no I need CASE statement but how to do the rest- full join table on itlself or some other options? </p>
  
  <p>Thanks!</p>