please i need answer for 7 and 8 thanks

. 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); 7) Find the names of all people who eat at least one pizza served by Dominos but who do not frequent Dominos #First find all the people who are Dominos frequent (inner query] SELECT FROM WHERE then select all the people who eat pizza which served by Dominos (join of Person, Eats and Serves tables give you this information, then exclude whoever is in the above list SELECT FROM WHERE AND.. AND AND