-- COMP3311 Simple Beer DB Queries

-- Q8. List of beers by each brewer

create or replace view Q8 as
...
;

-- Q9. Beers sold at bars where John drinks.

create or replace view Q9 as
...
;

-- Q10. Bars where either Gernot or John drink.

create or replace  view Q10 as
...
;

-- Q11. Bars where both Gernot and John drink.

create or replace view Q11 as
...
;

-- Q12. Bars where John drinks but Gernot doesn't

create or replace view Q12 as
...
;

-- Q13. Find bars that serve New at the same price
--      as the Coogee Bay Hotel charges for VB.

create or replace view Q13 as
...
;

-- Q14. Find the average price of common beers
--      ("common" = served in more than two hotels).

create or replace view Q14 as
...
;

-- Q15. Which bar sells 'New' cheapest?

create or replace view Q15 as
...
;

