Based on this SQL Diagram.

3. List all fields from the Merchandise table for items supplied by David Love.

4. List AnimalID of all Animals sold more than once. (Hint: requires a Having clause)

5. List the AnimalID of the Animals that have not been sold.

Customer Custom erID INT(11) Phone VARCHAR(45) FirstName VARCHAR(45) Sale Animal SaleID INT(11) Anim aID INT(11) SaleID INT(11) ? SaleDate DATE EmployeeID INT(11) ? SalePrice DECIMAL(6,2) Indexes ? LastName VARCHAR(45) -O Address VARCHAR(45) ZipCode VARCHAR(45) CityID INT(11) Animal Anim aID INT(11) Name VARCHAR(45) Category VARCHAR(45) Breed VARCHAR(45) Cusbom erID INT(11) ? SalesTax D Ed MAL(6,2) Indexes Indexes Employee EmployeeID INT(11) LastName VARCHAR(45) FirstName VARCHAR(45) Phone VARCHAR(45) Address VARCHAR(45) ZipCode VARCHAR(45) ? DateBorn DATE AnimalOrderItem OrderID INT(11) Anim aID INT(11) Cost DECIMAL (6,2) Gender VARCHAR(45) Registered WARCHAR 45) Color VARCHAR(45) ListPrice DECIMAL(6,2) AnimalOrder Indexes OrderID INT(11) OrderDate DATE ReceiveDate DATE ? SupplierID INT(11) Indexes TaxPayerID VARCHAR(45) DteHired DATE DateReleased DATE ManagerID INT (11) ShippingCost DECIMAL(6,2) SaleItem SaleID INT(11) ItemID INT(11) uantity INT (11) SalePrice DOUBLE (6,2) EmployeeID INT(11) Indexes EmployeeLevel INT(11) Title VARCHAR(45) Indexes |Merchandise ? ItemID INT(11) Description VARCHAR(45) QuantityonHand INT (11) Indexes MerchandiseOrder PONum ber INT(11) OrderDate DATE ReceiveDate DATE SupplierID INT(11) ?EmployeeID INT(11) OrderI tem PONum ber INT (11) ItemID INT(11) uantity INT (11) Cost DOUBLE(6,2) ListPrice DECIMAL(6,2) Category VARCHAR(45) CityID INT(11) ? ZipCode VARCHAR(45) ? City VARCHAR(45) Indexes Indexes State VARCHAR(45) AreaCode VARCHAR(45) Population 1990 INT(11) Population1980 INT(11)| Supplier | | ? ShippingCost DECIMAL(6,2) SupplierID INT(11) ? Name VARCHAR(45) Indexes | |?ContactName VARCHAR(45)| I ? Country VARCHAR(45) Phone VARCHAR(45) Address VARCHAR(45) ZipCode VARCHAR(45) CityID INT(11) Laitude DOUBLE Longitude DOUBLE Indexes Indexes