Ask Question
30 May, 04:17

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)
  1. 30 May, 04:28
    0
    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
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “find all breweries that specialize in a particular beer style. A brewer is considered specialized if they produce at least 10 beers from ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers