SELECT Product_Name FROM Products ORDER BY Product_Price DESC LIMIT 1
What is the name of the product with the highest price?
CREATE TABLE Addresses (
Address_ID INTEGER NOT NULL ,
address_details VARCHAR(255),
PRIMARY KEY (Address_ID),
UNIQUE (Address_ID)
);
CREATE TABLE Locations (
Location_ID INTEGER NOT NULL ,
Other_Details VARCHAR(255),
PRIMARY KEY (Location_ID)
);
CREATE TABLE Products (
Product_ID INTEGER NOT NULL,
Product_Type_Code CHAR(15),
Product_Name VARCHAR(255),
Product_Price DECIMAL(20,4),
PRIMARY KEY (Product_ID),
UNIQUE (Product_ID)
);
CREATE TABLE Parties (
Party_ID INTEGER NOT NULL,
Party_Details VARCHAR(255),
PRIMARY KEY (Party_ID)
);
CREATE TABLE Assets (
Asset_ID INTEGER NOT NULL ,
Other_Details VARCHAR(255),
PRIMARY KEY (Asset_ID)
);
CREATE TABLE Channels (
Channel_ID INTEGER NOT NULL ,
Other_Details VARCHAR(255),
PRIMARY KEY (Channel_ID)
);
CREATE TABLE Finances (
Finance_ID INTEGER NOT NULL ,
Other_Details VARCHAR(255),
PRIMARY KEY (Finance_ID)
);
CREATE TABLE Events (
Event_ID INTEGER NOT NULL ,
Address_ID INTEGER,
Channel_ID INTEGER NOT NULL,
Event_Type_Code CHAR(15),
Finance_ID INTEGER NOT NULL,
Location_ID INTEGER NOT NULL,
PRIMARY KEY (Event_ID),
UNIQUE (Event_ID),
FOREIGN KEY (Location_ID) REFERENCES Locations (Location_ID),
FOREIGN KEY (Address_ID) REFERENCES Addresses (Address_ID),
FOREIGN KEY (Finance_ID) REFERENCES Finances (Finance_ID)
);
CREATE TABLE Products_in_Events (
Product_in_Event_ID INTEGER NOT NULL,
Event_ID INTEGER NOT NULL,
Product_ID INTEGER NOT NULL,
PRIMARY KEY (Product_in_Event_ID),
FOREIGN KEY (Event_ID) REFERENCES Events (Event_ID),
FOREIGN KEY (Product_ID) REFERENCES Products (Product_ID)
);
CREATE TABLE Parties_in_Events (
Party_ID INTEGER NOT NULL,
Event_ID INTEGER NOT NULL,
Role_Code CHAR(15),
PRIMARY KEY (Party_ID, Event_ID),
FOREIGN KEY (Party_ID) REFERENCES Parties (Party_ID),
FOREIGN KEY (Event_ID) REFERENCES Events (Event_ID)
);
CREATE TABLE Agreements (
Document_ID INTEGER NOT NULL ,
Event_ID INTEGER NOT NULL,
PRIMARY KEY (Document_ID),
FOREIGN KEY (Event_ID) REFERENCES Events (Event_ID)
);
CREATE TABLE Assets_in_Events (
Asset_ID INTEGER NOT NULL,
Event_ID INTEGER NOT NULL,
PRIMARY KEY (Asset_ID, Event_ID),
FOREIGN KEY (Event_ID) REFERENCES Events (Event_ID),
FOREIGN KEY (Event_ID) REFERENCES Events (Event_ID)
);
INSERT INTO `Addresses` (`Address_ID`, `address_details`) VALUES (1, '465 Emely Bypass
INSERT INTO `Assets` (`Asset_ID`, `Other_Details`) VALUES (1, 'Transportation Cars');
INSERT INTO `Channels` (`Channel_ID`, `Other_Details`) VALUES (1, '145');
INSERT INTO `Finances` (`Finance_ID`, `Other_Details`) VALUES (1, 'Mutual');
INSERT INTO `Locations` (`Location_ID`, `Other_Details`) VALUES (1, 'Rowe PLC');
INSERT INTO `Parties` (`Party_ID`, `Party_Details`) VALUES (3, 'European People''s Party');
INSERT INTO `Products` (`Product_ID`, `Product_Type_Code`, `Product_Name`, `Product_Price`) VALUES (1, 'Books', 'Business Policy', '1336.2600');
INSERT INTO `Events` (`Event_ID`, `Address_ID`, `Channel_ID`, `Event_Type_Code`, `Finance_ID`, `Location_ID`) VALUES (1, 3, 12, 'Trade Show', 2, 13);
INSERT INTO `Products_in_Events` (`Product_in_Event_ID`, `Event_ID`, `Product_ID`) VALUES (13, 4, 29);
INSERT INTO `Parties_in_Events` (`Party_ID`, `Event_ID`, `Role_Code`) VALUES (3, 7, 'Organizer');
INSERT INTO `Agreements` (`Document_ID`, `Event_ID`) VALUES (13, 5);
INSERT INTO `Assets_in_Events` (`Asset_ID`, `Event_ID`) VALUES (1, 4);