title: How can I split a column at two sql
body: <p>I have a table boat with the columns and attributes bellow.</p>
  
  <pre>
  +-----+--------+-------------+
  | bid | bname  | color       |
  +-----+--------+-------------+
  |  88 | Sophie | Blue        |
  |  17 | Kate   | Light Green |
  |  13 | Peter  | Yellow      |
  |   1 | Nicola | Red         |
  |  72 | Christ | Red         |
  |  19 | Rick   | Light Green |
  |  77 | Morty  | Blue        |
  +-----+--------+--------+----+
  </pre>
  
  <p>How can I print a table that match boats names with same color like:</p>
  
  <pre>
  +--------+--------+
  | boat1  | boat2  |
  +--------+--------+
  | Sophie | Morty  |
  | Kate   | Rick   |
  | Nicola | Christ |
  +--------+--------+
  </pre>
  
  <p>Thanks in advance..</p>