SELECT MIN(usageWhen), MAX(usageWhen), (SELECT ksc.computerDivisionID FROM KSComputers ksc JOIN KSComputerDivisions ksd ON ksc.computerDivisionID = ksd.divisionID WHERE ksc.computerDivisionID != 0 GROUP BY ksc.computerDivisionID) divisionID FROM KSUsage WHERE usageEvent = 16;