Well, I did say "which can be collapsed into two if you want to get fancy".

***

Your group by will result in a 24x25x20 number of rows. You still need to then do a join. You do the join, and do sum(s.RE)/sum(n), sum(e.RE + runsOnPlay)/sum(n), and GROUP BY eventType.

Or you can collapse the two into one query, as I showed earlier.

***

Your group by will result in a 24x25x20 number of rows. You still need to then do a join. You do the join, and do sum(s.RE)/sum(n), sum(e.RE + runsOnPlay)/sum(n), and GROUP BY eventType.

Or you can collapse the two into one query, as I showed earlier.

## Comment