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

Thomas Clements

Computers & Technology

26 November, 05:10

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.

+4

Answers (1)

Know the Answer?

Sidney Stone · 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