Proper violations per day query