What I am doing is trying to get a combined solution set.
Basically I want to combine the results of these two queries:
Select Event_id,Question_id,Response,AgeGroup,Sum(Quantity)
From Event_line
Group by Event_id,Question_id,Response,AgeGroup
and
Select AgeGroup, Sum(Quantity)
From Event_line
Group by AgeGroup
individually run they give the correct result, however when combined by using a self-join,
I am getting double counting. See my attached Word document to see what I am getting as opposed to the desired result.