Aggregations with lookups