多个选择子查询计数基于一天中的时间，想要添加表/列

Right now, I have a multiple select subquery that is grabbing data based on hour of the day that's a count. What I want to do now, is to introduce another table into that query, and count based on an id as well as the datetime in the original table.Right now, I have a multiple select subquery th