SELECT name FROM press ORDER BY Year_Profits_billion DESC
list all the names of press in descending order of the profit of the year.
CREATE TABLE "author" (
"Author_ID" int,
"Name" text,
"Age" int,
"Gender" text,
PRIMARY KEY ("Author_ID")
);
CREATE TABLE "press" (
"Press_ID" int,
"Name" text,
"Month_Profits_billion" real,
"Year_Profits_billion" real,
PRIMARY KEY ("Press_ID")
);
CREATE TABLE "book" (
"Book_ID" int,
"Title" text,
"Book_Series" text,
"Author_ID" int,
"Press_ID" int,
"Sale_Amount" text,
"Release_date" text,
PRIMARY KEY ("Book_ID"),
FOREIGN KEY (`Author_ID`) REFERENCES `author`(`Author_ID`),
FOREIGN KEY (`Press_ID`) REFERENCES `press`(`Press_ID`)
);
INSERT INTO  "author" VALUES (1,"Derrick Kosinski",45,"Male");
INSERT INTO  "press" VALUES (1,"Accor","0.65","6.02");
INSERT INTO  "book" VALUES (1,"Book Revue","LT",1,1,"1234","2016-01-05");