write SQL queries for the

C) Find the maximum price of a pizza served by each pizzeria under $25.00

d) Find all pizzerias that are frequented by only males. Hint: There may be pizzerias frequented by both males and females.

Consider a database with the following schema: Person (name, age, gender) name is a key Frequents (name, pizzeria) (name, pizzeria) is a key Eats (name, pizza ) Serves (pizzeria, pizza, price) (pizzeria, pizza) is a key (name, pizza) is a key Write relational algebra expressions for the following queries. Each pizza comes only with one topping: 7 8 a) Find the names of all females who eat either mushroom or pepperoni pizza (or both) b) Find the names of all females who eat both mushroom and pepperoni pizzas. 2018/5/17 13:28