FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

  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);

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials Of Business Analytics

Essentials Of Business Analytics

Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams

1st Edition

128518727X, 978-1337360135, 978-1285187273

More Books

Students also viewed these Databases questions

Question

★★★★★
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...

Answered: 1 week ago

Question

★★★★★
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Answered: 1 week ago

Question

★★★★★
The file FdiCBankFailures contains data on failures of federally insured banks between 2000 and 2012. Create a PivotTable in Excel to answer the following questions. The Pivot- Table should group the...

Answered: 1 week ago

Question

★★★★★
Regulation imperial soccer fields have a length of 91 meters and a width of 39 meters. Show that during a friendly match there are always two players that are not farther from each other than 19...

Answered: 1 week ago

Question

★★★★★
Canyon Canoe Company has experienced rapid growth in its first few months of operations and has had a significant increase in customers renting canoes and purchasing T-shirts. Many of these customers...

Answered: 1 week ago

Question

★★★★★
Bender Corporation incurs the following annual fixed costs. Item Cost Depreciation ....... $ 34,000 Officers salaries .... 120,000 Long-term lease ..... 42,000 Property taxes ....... 9,000 Required...

Answered: 1 week ago

Question

★★★★★
How would you help your students evaluate the information they are finding on the Web?

Answered: 1 week ago

Question

★★★★★
On January 1, 2014, Abraham Company purchased the following two machines for use in its production process. Machine A: The cash price of this machine was $55,000. Related expenditures included: sales...

Answered: 1 week ago

Question

★★★★★
Exercise 1: A refrigerator with R134 a as the working fluid has a minimum temperature of 10C and a maximum pressure of 1MPa. Assume an ideal refrigeration cycle. Find the specific heat transfer from...

Answered: 1 week ago

Question

★★★★★
The graph below shows the hours studied and the test grades on a biology test for 7 students. The red line on the graph can be used to approximate the test grade the average student receives for the...

Answered: 1 week ago

Question

★★★★★
Required information [The following information applies to the questions displayed below.) Major League Apparel has two classes of stock authorized: 6%. $10 par preferred, and $1 par value common....

Answered: 1 week ago

Question

★★★★★
Customers entering a hardware store are asked how many rooms are in their house. The results are displayed in the following frequency table. Which histogram accurately summarizes the data? Select the...

Answered: 1 week ago

Question

★★★★★
McDonald's Russia: Managing a Crisis - The McDonald's case is old, but some of the lessons about market entry and risk are relevant, especially now in the time of COVID-19 and with the invasion of...

Answered: 1 week ago

Question

★★★★★
Jan and Sue are general partners in CKY Bake Shop and share equally in profits and losses. They have no employees. They have the following income and expenses for the current tax year: Gross receipts...

Answered: 1 week ago

Question

★★★★★
A tourist named Mr. Lopez from Chile visited Arlington and bought a ticket for the Dallas Cowboys game. During his stay, he also paid for his hotel, meals, and various items from local shops, which...

Answered: 1 week ago

Question

★★★★★
Problem 3-15 (Static) Journal Entries; T-Accounts; Financial Statements [LO3-1, LO3-2, LO3-3, LO3-4] Froya Fabrikker A/S of Bergen, Norway, is a small company that manufactures specialty heavy...

Answered: 1 week ago

Question

★★★★★
The following data are accumulated by Watershed inc. in evaluating two competing capital investment proposais

Answered: 1 week ago

Question

★★★★★
Write a program to move a signed number from smaller register to bigger register. Hint: movzx ax, bl Topic: Data Related Operators and Directives in assembly language

Answered: 1 week ago

Question

★★★★★
The owner of an automobile repair shop studied the waiting times for customers who arrive at the shop for an oil change. The following data with waiting times in minutes were collected over a 1-month...

Answered: 1 week ago

Question

★★★★★
Andalus Furniture Company has two manufacturing plants, one at Aynor and another at Spartanburg. The cost in dollars of producing a kitchen chair at each of the two plants is given here. The cost of...

Answered: 1 week ago

Question

★★★★★
A creative entrepreneur has created a novelty soap called jackpot. Inside each bar of jackpot soap is a rolled-up bill of U.S. currency. There are 1000 bars of soap in the initial offering of the...

Answered: 1 week ago

Question

★★★★★
A decision maker wishes to test the following null and alternative hypotheses using an alpha level equal to 0.05: The population standard deviations are assumed to be known. After collecting the...

Answered: 1 week ago

Question

★★★★★
The owner of the A.J. Fitness Center is interested in estimating the difference in mean years that female members have been with the club compared with male members. He wishes to develop a 95%...

Answered: 1 week ago

Question

★★★★★
Given the following null and alternative hypotheses together with the following sample information a. Assuming that the populations are normally distributed with equal variances, test at the 0.10...

Answered: 1 week ago

Previous Question Next Question