First Query Co-Related sub query table variables (temporary tables) count events by 2 shift cycles using derived table №1 BC160401693 EXP 8 q2 dbray SQL Where, And