Can use join clause in the same bucket?

[geraldss]

HI,

SELECT breweries.name AS brewery, ARRAY_AGG(beers.name) AS beer_names
FROM beer-sample AS beers
JOIN beer-sample AS breweries ON KEYS beers.brewery_id
where breweries.name = 'Bullfrog Brewery’
GROUP BY breweries.name;