Ask Question
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)
  1. 20 March, 04:00
    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?
Find 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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers