The results are almost correct except one minor issue.
The original Query 1 with
GroupID = 20:
GroupID | MyName | Age | Rating | Animal | Mood |
---|
20 | David | 1 | 1 | Leopard | Good |
20 | David | 1 | 2 | Cheetah | Good |
20 | David | 1 | 2 | Leopard | Bad |
20 | David | 1 | 3 | Cheetah | Good |
20 | David | 1 | 3 | Leopard | Good |
Your updated Output code for
GroupID = 20:
GroupID | MyName | Age | Rating | Animal | Mood |
---|
20 | David | 1 | 1 | Leopard | Good |
20 | David | 1 | 2 | Leopard | Bad |
20 | David | 1 | 2 | Cheetah | Good |
20 | David | 1 | 3 | Leopard | Good |
There appears to be a duplicate where
Leopard = Bad, and
Cheetah = Good. It should just should
Leopard = Bad.