the query in question is definitely case b - it's a group by query with an explicit granularity, there's just no actual aggregates being asked for but the very

the query in question is definitely case b - it's a group by query with an explicit granularity, there's just no actual aggregates being asked for but the very presence or absence of a row in the results carries some meaning. the explicit grain is something like employee markouts plus customers from stores with at least one employee without markouts.