I am trying to create a query that lists beers by brewery. I created the following N1QL:
select br.name brewery
, b.name beer
, b.style style
from `beer-sample` b
join `beer-sample` br on keys b.brewery_id
where br.city = "Philadelphia"
group by br.name;
and I got the following error:
[
{
"code": 4210,
"msg": "Expression must be a group key or aggregate: (`b`.`name`)",
"query_from_user": "select br.name brewery\n, b.name beer\n, b.style style \nfrom `beer-sample` b\njoin `beer-sample` br on keys b.brewery_id\nwhere br.city = \"Philadelphia\"\ngroup by br.name;"
}
]
How would I fix this query to return an JSON object for each brewery containing an array of beers?