There is such a SQL query:

SELECT `quadKey`, MIN(id) AS id, COUNT(id) AS count, AVG(longitude) AS longitude, AVG(latitude) AS latitude FROM marker WHERE quadKey between 15499682906112 and 15499683168255 GROUP BY (quadKey & 15499683151872);

Tell me how to transfer it to Objective-C, in particular, how to apply a mask to the GROUP BY operator. Here is a part of my code:

 NSFetchRequest *fetchRequest = [NSFetchRequest fetchRequestWithEntityName:@"GBVenue"]; NSExpressionDescription *countExpressionDescription = [self expressionForFunction:@"count:" arguments:@[[NSExpression expressionForKeyPath: @"priority"]] resultName:@"count" resultType:NSDoubleAttributeType]; .... [fetchRequest setPropertiesToFetch:@[@"quadKey", countExpressionDescription, minIdExpressionDescription, averageLongitudeExpressionDescription, averageLatitudeExpressionDescription, minLongitudeExpressionDescription, minLatitudeExpressionDescription, maxLongitudeExpressionDescription, maxLatitudeExpressionDescription]]; [fetchRequest setPropertiesToGroupBy:@[@"quadKey"]]; [fetchRequest setResultType:NSDictionaryResultType]; quadKey", countExpressionDescription, minIdExpressionDescription, averageLongitudeExpressionDescription, averageLatitudeExpressionDescription, minLongitudeExpressionDescription, minLatitudeExpressionDescription, maxLongitudeExpressionDescription, maxLatitudeExpressionDescription]]; NSFetchRequest *fetchRequest = [NSFetchRequest fetchRequestWithEntityName:@"GBVenue"]; NSExpressionDescription *countExpressionDescription = [self expressionForFunction:@"count:" arguments:@[[NSExpression expressionForKeyPath: @"priority"]] resultName:@"count" resultType:NSDoubleAttributeType]; .... [fetchRequest setPropertiesToFetch:@[@"quadKey", countExpressionDescription, minIdExpressionDescription, averageLongitudeExpressionDescription, averageLatitudeExpressionDescription, minLongitudeExpressionDescription, minLatitudeExpressionDescription, maxLongitudeExpressionDescription, maxLatitudeExpressionDescription]]; [fetchRequest setPropertiesToGroupBy:@[@"quadKey"]]; [fetchRequest setResultType:NSDictionaryResultType];

    0