1. Which pirates had the greatest number of hauls that were either gold or silver? Which ones did not plunder any gold or silver? Answer these questions by writing a single query to display all 10 pirates with the combined number of treasure hauls of gold or silver for each, sorted by the number of hauls in descending order. Display pirate name and # of hauls, ensuring descriptive column names. Any pirates with no gold or silver hauls should show a value of "0". Ensure descriptive column names.

Here is the data that can just be copied in for the table creation and their values:

Scripts

CREATETABLE PIRATE(

PirateID smallintnotnull,

Name VARCHAR(30)NOTNULL,

Age smallint,

HasParrot bit,

HasPegLeg bit,

CONSTRAINT pirate_pkPRIMARYKEY(PirateID)

);

CREATETABLE TREASURE(

TreasureID INTNOTNULLIdentity(1,1),

Category varchar(20)CHECK(CategoryIN('Gold','Jewels','Spices','Silver','Art','Other')),

DateOfPlunder date,

PirateID smallint,

constraint plunder_fkFOREIGNKEY(PirateID)REFERENCES PIRATE(PirateID)ONDELETECASCADE

);

CREATETABLE SHIP(

ShipID SMALLINTNOTNULL,

ShipName VARCHAR(30),

NumOfCannons smallint,

ShipType varchar(20),

CONSTRAINT ship_pkPRIMARYKEY(ShipID)

);

ALTERTABLE SHIPADDCONSTRAINT check_ship_typeCHECK(ShipTypeIN('Sloop','Schooner','Galleon','Man of War','Frigate'));

CREATETABLE RESERVATION(

ReservationNumINTNOTNULLIdentity(1,1),

CheckOutDate DATE,

CheckInDate DATE,

ReturnDueDate DATE,

PirateID smallint,

ShipNum smallint,

CONSTRAINT reservation_pkPRIMARYKEY(ReservationNum),

CONSTRAINT reservation_fk1FOREIGNKEY(PirateID)REFERENCES PIRATE(PirateID)ONDELETECASCADE,

CONSTRAINT reservation_fk2FOREIGNKEY(ShipNum)REFERENCES SHIP(ShipID)ONDELETECASCADE

);

--PIRATE rows

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(1,'Blackbeard',41,0,0);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(2,'Calico Jack',30,0,0);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(3,'Black Bart',38,1,1);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(4,'Anne Bonny',24,0,0);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(5,'Henry Morgan',40,0,1);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(6,'Captain Kidd',42,0,0);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(7,'Bartholomew Roberts',51,0,0);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(8,'Jean Lafitte',43,0,0);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(9,'Jack Sparrow',26,1,0);

INSERTINTO PIRATE(PirateID,Name, Age,HasParrot, HasPegLeg) VALUES(10,'Long John Silver',34,1,1);

--SHIP rows

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1000,'Black Pearl',18,'Schooner');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1001,'Jolly Roger',36,'Sloop');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1002,'Adventure Galley',34,'Galleon');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1003,'Queen Anne''s Revenge',40,'Frigate');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1004,'Fancy',46,'Galleon');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1005,'Whydah',30,'Schooner');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1006,'Royal Fortune',40,'Frigate');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1007,'Flying Dutchman',18,'Man of War');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1008,'Satisfaction',12,'Sloop');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1009,'Golden Hind',18,'Galleon');

INSERTINTO SHIP(ShipID, ShipName, NumOfCannons,ShipType) VALUES(1010,'Liberty',33,'Man of War');

--RESERVATION rows

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('03/31/1716','04/07/1716','04/05/1716',4,1000);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('03/31/1716','04/14/1716','04/09/1716',1,1008);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('03/31/1716','04/14/1716','04/03/1716',8,1000);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('03/31/1716','04/07/1716','04/08/1716',4,1003);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('03/31/1716','04/14/1716','04/09/1716',8,1001);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/05/1716','04/12/1716','04/13/1716',10,1005);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/05/1716','04/12/1716','04/08/1716',5,1002);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/05/1716','04/12/1716','04/06/1716',4,1009);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/05/1716','04/19/1716','04/09/1716',2,1003);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/05/1716','04/19/1716','04/05/1716',6,1005);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/05/1716','04/12/1716','04/11/1716',7,1008);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/08/1716','04/15/1716','04/12/1716',1,1002);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/10/1716','04/24/1716','04/19/1716',8,1000);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/11/1716','04/18/1716','04/19/1716',5,1001);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/11/1716','04/18/1716','04/13/1716',9,1004);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/13/1716','04/27/1716','04/14/1716',3,1003);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/14/1716','04/21/1716','04/22/1716',3,1002);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/14/1716','04/28/1716','04/14/1716',3,1005);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/14/1716','04/21/1716','04/17/1716',9,1009);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/16/1716','04/23/1716','04/23/1716',7,1008);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/16/1716','04/23/1716','04/21/1716',1,1006);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/16/1716','04/23/1716','04/19/1716',9,1008);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/16/1716','04/23/1716','04/19/1716',2,1002);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/21/1716','04/28/1716','04/29/1716',5,1000);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/21/1716','04/28/1716','04/27/1716',4,1004);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/21/1716','05/04/1716','04/26/1716',2,1005);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/21/1716','05/04/1716','04/26/1716',2,1006);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/22/1716','05/05/1716','04/30/1716',8,1001);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/22/1716','04/29/1716','04/26/1716',6,1001);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/22/1716','04/29/1716','04/30/1716',2,1007);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/23/1716','05/06/1716','04/30/1716',1,1007);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/23/1716','04/30/1716','04/26/1716',8,1001);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/23/1716','04/30/1716','04/23/1716',8,1004);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/23/1716','04/30/1716','05/01/1716',4,1009);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/24/1716','05/07/1716','04/25/1716',6,1006);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/24/1716','04/30/1716','04/28/1716',7,1008);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/28/1716','05/04/1716','05/01/1716',4,1000);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/28/1716','05/04/1716','04/30/1716',6,1003);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/28/1716','05/04/1716','05/06/1716',10,1003);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/28/1716','05/04/1716','05/05/1716',4,1009);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/28/1716','05/04/1716','04/30/1716',8,1007);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/29/1716','05/05/1716','05/05/1716',10,1001);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/29/1716','05/05/1716','05/07/1716',5,1007);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/30/1716','05/07/1716','05/08/1716',9,1006);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/30/1716','05/07/1716','05/04/1716',6,1002);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/30/1716','05/07/1716','05/03/1716',10,1004);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('04/30/1716','05/07/1716','05/07/1716',1,1005);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/04/1716','05/11/1716','05/06/1716',1,1000);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/04/1716','05/11/1716','05/04/1716',5,1006);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/08/1716','05/15/1716','05/13/1716',5,1009);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/08/1716','05/15/1716','05/15/1716',5,1000);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/08/1716','05/15/1716','05/08/1716',6,1001);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/09/1716','05/16/1716',NULL,2,1006);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/09/1716','05/16/1716','05/11/1716',4,1003);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/09/1716','05/16/1716','05/10/1716',5,1004);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/10/1716','05/17/1716','05/15/1716',4,1002);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/10/1716','05/17/1716','05/11/1716',1,1007);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/10/1716','05/17/1716','05/15/1716',8,1006);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/10/1716','05/17/1716','05/15/1716',4,1004);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/15/1716','05/22/1716','05/18/1716',3,1007);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/15/1716','05/22/1716',NULL,9,1002);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/15/1716','05/22/1716','05/16/1716',1,1003);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/15/1716','05/22/1716','05/20/1716',1,1005);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/17/1716','05/31/1716','05/21/1716',5,1007);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/17/1716','05/24/1716','05/17/1716',4,1008);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/19/1716','05/26/1716',NULL,6,1009);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/24/1716','05/31/1716',NULL,5,1005);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/24/1716','05/31/1716',NULL,4,1004);

INSERTINTO RESERVATION(CheckOutDate,ReturnDueDate, CheckInDate,PirateID,ShipNum)VALUES('05/24/1716','05/31/1716',NULL,4,1010);

--TREASURE rows

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 04/03/1716',8);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 04/05/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 04/05/1716',6);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 04/06/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 04/08/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 04/08/1716',5);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 04/09/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 04/09/1716',8);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 04/09/1716',2);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 04/11/1716',7);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 04/12/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 04/13/1716',10);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 04/13/1716',9);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 04/14/1716',3);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 04/14/1716',3);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Spices',' 04/17/1716',9);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 04/19/1716',8);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 04/19/1716',5);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 04/19/1716',9);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 04/19/1716',2);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 04/21/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 04/22/1716',3);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 04/23/1716',7);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Spices',' 04/23/1716',8);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 04/25/1716',6);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 04/26/1716',2);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 04/26/1716',2);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 04/26/1716',6);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 04/26/1716',8);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 04/27/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 04/28/1716',7);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 04/29/1716',5);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 04/30/1716',8);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 04/30/1716',2);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 04/30/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 04/30/1716',6);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Spices',' 04/30/1716',8);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 05/01/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 05/01/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 05/03/1716',10);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 05/04/1716',6);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 05/04/1716',5);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 05/05/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 05/05/1716',10);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 05/06/1716',10);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Spices',' 05/06/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 05/07/1716',5);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 05/07/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Spices',' 05/08/1716',9);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 05/08/1716',6);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 05/10/1716',5);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 05/11/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Spices',' 05/11/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Gold',' 05/13/1716',5);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 05/15/1716',5);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Spices',' 05/15/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Silver',' 05/15/1716',8);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Other',' 05/16/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Spices',' 05/17/1716',4);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 05/18/1716',3);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Jewels',' 05/20/1716',1);

INSERTINTO TREASURE(Category,DateofPlunder,PirateID) VALUES('Art',' 05/21/1716',5);