SELECT LocationID, SUM(IIF(ShiftStart < CTOT('09/25/2003 1:30:00 PM') .AND. ShiftEnd > CTOT('09/25/2003 1:59:59 PM'),1,0))/2 as one30_pm ;
	FROM Emp JOIN Shift ;
	ON emp.empid = shift.empid ;
	GROUP BY LocationID