-- Q16 Which bar is most popular? 

create or replace view q16(bar) as
...
;

-- Q17 Which bar is most expensive?
-- (max average drink price)

create or replace view q17(bar) as
...
;
-- Q18 Price of cheapest beer at each bar?

create or replace q18(bar,price) as
...
;

-- Q19 Name of cheapest beer at each bar?

create or replace q19(bar,beer) as
...
;

-- Q20 Which beers are sold at all bars?

create or replace q20(beer) as
...
;

-- Q21 How many drinkers are in each suburb?

create or replace q21(suburb,ndrinkers) as
...
;

-- Q22 How many bars in suburbs where drinkers live?

create or replace q22(suburb,nbars) as
...
;
