To page explains why the Solution by SQL solves the puzzle Color Coordination Puzzle

If you run the SQL here is what you will get:

blk_num | color_position | color_cd |
---|---|---|

2 | 0 | Y |

1 | 2 | R |

6 | 4 | W |

0 | 3 | G |

3 | 1 | X |

4 | 5 | B |

5 | 0 | Y |

What does this output mean?

The table CIRCLES has the following definition:

BLK_NUM is the Block Number or the Piece Number (corresponds to each cookie and ranges from 0 to 6) COLOR_POSITION ranges from 0 to 5 and is useful in determining the sequence of the dots on the cookie COLOR_CD is of course the color of the dot.

When we defined the table data each cookie was given a number from 0 to 6. This is the original number.

The result is the order in which you need to place the cookies (based on the original number). So you place cookie # 2, 1st and keep going clockwise, placing cookie #1 next and so on until you complete the circle. You place the last cookie (# 5) in the center.

The 2nd and 3rd values in the output help you rotate the placed cookies and align the dots. So rotate (or place cookie) # 1 so that Yellow is facing the center. Red dot faces center for cookie # 2 and so on.

Check out the picture below as well for the explanation of the solution above.