To page explains why the [[tech:others:color_coordination_puzzle_solution_by_sql|Solution by SQL]] solves the puzzle [[tech:others:color_coordination_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. 

{{general:discs_puzzle_sol.jpg|}}