please i need answer for 1-3 thank you
. DROP DATABASE IF EXISTS pizza; CREATE DATABASE pizza; use pizza; /* Delete the tables if they already exist / drop table if exists Person; drop table if exists Frequents; drop table if exists Eats; drop table if exists Serves; /* Create the schema for our tables */ create table Person (name text, age int, gender text); create table Frequents(name text, pizzeria text); create table Eats (name text, pizza text); create table serves (pizzeria text, pizza text, price decimal(10,2)); /* Populate the tables with our data */ insert into Person values ('Amy', 16, 'female'); insert into Person values('Ben, 21, *male'); insert into Person values('Cal', 33, male'); insert into Person values('Dan, 13, male'); insert into Person values('Eli', 45, 'male'); insert into Person values('Fay', 21, * female'); insert into Person values('Gus', 24, 'male'); insert into Person values( 'Hil', 30, 'female'); insert into Person values('Ian', 18, male'); insert into Frequents values ('Amy', Pizza Hut'); insert into Frequents values('Ben', Pizza Hut'); insert into Frequents values('Ben', 'Chicago Pizza'); insert into Frequents values('Cal', 'Straw Hat'); insert into Frequents values('Cal', 'New York Pizza'); insert into Frequents values('Dan', 'Straw Hat'); insert into Frequents values('Dan', 'New York Pizza'); insert into Frequents values('Eli', 'Straw Hat'); insert into Frequents values('Eli', Chicago Pizza'); insert into Frequents values('Fay, 'Dominos' ); insert into Frequents values('Fay', 'Little Caesars' ); insert into Frequents values('Gus', 'Chicago Pizza'); insert into Frequents values('Gus', Pizza Hut'); insert into Frequents values('Hil', 'Dominos'); insert into Frequents values('Hil', 'Straw Hat'); insert into Frequents values('Hil', 'Pizza Hut'); insert into Frequents values('Ian' "New York Pizza'); insert into Frequents values('Ian', 'Straw Hat'); insert into Frequents values( 'Ian', 'Dominos'); insert into Eats values (Amy pepperoni'); insert into Eats values('Amy mushroom'); insert into Eats values('Ben pepperoni'); insert into Eats values('Ben 'cheese"); insert into Eats values('Cal' supreme'); insert into Eats values('Dan pepperoni'); insert into Eats values('Dan' 'cheese'); insert into Eats values('Dan 'sausage'); insert into Eats values('Dan', supreme' ); insert into Eats values('Dan mushroom'); insert into Eats values('Eli' supreme'); insert into Eats values('Eli', cheese'); insert into Eats values( 'Fay mushroom'); insert into Eats values('Gus 'mushroom'); insert into Eats values('Gus' supreme'); insert into Eats values ( 'Gus cheese'); insert into Eats values('Hill, supreme'); insert into Eats values('Hil' cheese'); insert into Eats values('Ian', 'supreme' ); insert into Eats values('Ian', pepperoni'); insert into Serves values('Pizza Hut', 'pepperoni', 12); insert into Serves values('Pizza Hut', 'sausage, 12); insert into Serves values('Pizza Hut', 'cheese', 9); insert into Serves values('Pizza Hut', supreme 12); insert into Serves values ('Little Caesars', pepperoni', 9.75); insert into serves values ('Little Caesars', 'sausage', 9.5); insert into Serves values('Little Caesars', cheese', 7); insert into Serves values ('Little Caesars, mushroom', 9.25); insert into Serves values('Dominos', 'cheese', 9.75); insert into Serves values ( Dominos', 'mushroom, 11); insert into Serves values ( 'Straw Hat', 'pepperoni', 8); insert into Serves values ( 'Straw Hat, cheese, 9.25); insert into Serves values('Straw Hat', 'sausage' 9.75); insert into Serves values ("New York Pizza', 'pepperoni', 8); insert into serves values ( "New York Pizza', cheese', 7); insert into Serves values('New York Pizza', supreme', 8.5); insert into Serves values('Chicago Pizza', 'cheese 7.75); insert into Serves values('Chicago Pizza', supreme', 8.5); 1) Find all people who are male and over 18 2) Find the names of people who are female and over 30 3) Find the names of people who are male and over 20 and who eats cheese pizza
