SELECT Name FROM ship WHERE Nationality != "United States"
What are the names of the ships that are not from the United States?
CREATE TABLE "mission" (
"Mission_ID" int,
"Ship_ID" int,
"Code" text,
"Launched_Year" int,
"Location" text,
"Speed_knots" int,
"Fate" text,
PRIMARY KEY ("Mission_ID"),
FOREIGN KEY ("Ship_ID") REFERENCES `ship`("Ship_ID")
);
CREATE TABLE "ship" (
"Ship_ID" int,
"Name" text,
"Type" text,
"Nationality" text,
"Tonnage" int,
PRIMARY KEY ("Ship_ID")
);
INSERT INTO  "ship" VALUES (1,"Corbridge","Cargo ship","United Kingdom","3687");
INSERT INTO  "mission" VALUES (1,1,"VMV-1","1930","Germany","25","Decommissioned 1950");