Question

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.

Answer 1

Answer:

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

Explanation: