Cannot resolve ambiguous alias reference for undefined identifier num_beers in [#1, $brewery_id]

create bucket beerBucket with {"name":"beer-sample"};

create shadow dataset beers on beerBucket WHERE `type`="beer";

create shadow dataset breweries on beerBucket WHERE `type`="brewery";

connect bucket beerBucket;

SELECT br.brewery_id, COUNT(*) AS num_beers FROM beers br GROUP BY br.brewery_id HAVING num_beers > 30 and br.brewery_id != "";