The result that I'm getting is three instances of Item 7 each with the different color.

You need to either narrow the query or filter the results.

  SELECT * FROM ...
[download]

is giving what you ask for, which is more than what you want.

  SELECT DISTINCT item_id, color FROM ...
[download]

might work better. Try the two queries from a command-line query tool to see the difference.