title: Co-occur colors of outfit, SQL
body: <p>Say I have a data Table, two columns</p>
  
  <p><img src="https://i.stack.imgur.com/M6Yvf.png" alt="DATA TABLE"></p>
  
  <p>How would I write code in SQL that shows the top two co-occuring colors. So the output should be a table with two columns (color and count) . ex "Green","Red" 3, "Blue" "Blue" 2, "Pink" "Purple" 1. I'm working with a big dataset so I would want something a little simpler to use.</p>