need complete SQL query answer for No. 9. The Database schema is on the right (those underlined are primary keys) please ignore the table under the question.

Consider the beer drinker's database underlined 9 For each beer. find its average price and popularity Imeasured by the number of drinkers who like it) Sort the autput by average prce Average Price Popularity Beer Rainier Beer Budweiser Bud light Corona Extra Drinker (name, address) Bar (name, address) Beer (name, brewer) Frequents (drinker, bar, times a_week) Likes (drinker, beer) Serves (bar, beer, price) 2.5 2.5625 3.983333333 3 Samuel Adams Dark 4 Beck's Blonde Heineken Alaskan Amber Guiness Stout Prime Time Pale Ale 5. 4.0625 175 4.875 Answer the following questions: Big Hom Hefeweizen 5.75 Bhagwan's Best IPA 5.75 Big Red 1.PA Mac and Jack's Amber 6 1. Find all drinkers who frequent Big names and addresses