find all breweries that specialize in a particular beer style. A brewer is considered specialized if they produce at least 10 beers from the same style. Show the brewer's name, style name, and how many beers the brewer makes of that style. Display the records by style name first and then by breweries with the most beers within that style.

Question

Computers and Technology

Janetta

20 March, 02:48

find all breweries that specialize in a particular beer style. A brewer is considered specialized if they produce at least 10 beers from the same style. Show the brewer's name, style name, and how many beers the brewer makes of that style. Display the records by style name first and then by breweries with the most beers within that style.

+3

Answers (1)

Know the Answer?

Hugo Armstrong · Answer 1

select style_name, br. name as brewery, count (beer_id) as Num

from beerdb. beers be

inner join beerdb. styles st

on be. style_id = st. style_id

join beerdb. breweries br on

be. brewery_id = br. brewery_id

group by style_name, br. name

having count (beer_id) >=10

order by style_name, num desc