car_owners_summary
is a query that should return a summarization of car owner information (with time granularity as an optional argument)
The part I was curious about was how you feel about "row count increasing by adding one additional field in the query". Essentially, when fields are added to the query, it returns a cross product between two tables.
{
car_owners_summary {
gender
}
}
{
car_owners_summary: [{
gender: "male"
},{
gender: "female"
}]
}
{
car_owners_summary {
gender
state
}
}
{
car_owners_summary: [{
gender: "male",
state: "TX"
},{
gender: "male",
state: "CA"
},{
gender: "female",
state: "MI"
},{
gender: "female",
state: "CA"
},{
gender: "female",
state: "TX"
},{
gender: "female",
state: "WA"
},{
gender: "female",
state: "NV"
}]
}