SELECT Orders.[Ticket ID], Sum(Orders.Number) AS [house supporters], Customer.[House Team]
FROM Customer INNER JOIN Orders ON Customer.[Customer ID] = Orders.[Customer ID]
GROUP BY Orders.[Ticket ID], Customer.[House Team]
HAVING (((Orders.[Ticket ID]) In ('F1','F2','F3')) AND ((Customer.[House Team]) In ('Alpha','Gamma','Beta','Delta')));