title: Update sql columns with true or false
body: <p>I would like to update the columns Brand A, Brand B and Brand C with results of either "true" or "false", based on the <b>customer_code column</b> and the <b>Brand column</b>. </p>
  
  <p>For example, table <b>market</b> shows the following:
   I have a customer who bought brand A and B:</p>
  
  <pre><code>Customer_code   Brand   Brand A Brand B Brand C
  1234567            A    NULL    NULL    NULL
  1234567            B    NULL    NULL    NULL
  
  
  Customer_code   Brand   Brand A Brand B Brand C
  1234567           A     True    True    False
  1234567           B     True    True    False
  </code></pre>
  
  <p>As I have quite a large number of data so is there any way to solve this?</p>
  
  <p>Thank you so much!</p>