SQL - 在一个语句中使用查询结果作为另外两个查询的基础

I'm doing a probability calculation. I have a query to calculate the total number of times an event occurs. From these events, I want to get the number of times a sub-event occurs. The query to get the total events is 25 lines long and I don't want to just copy + paste it twice. I'm doing a probability calculation. I have a q