SELECT TYPE FROM book GROUP BY TYPE ORDER BY COUNT(*) DESC LIMIT 1
What is the most common type of books?
CREATE TABLE "book" (
"Book_ID" int,
"Title" text,
"Type" text,
"Pages" int,
"Chapters" int,
"Audio" text,
"Release" text,
PRIMARY KEY ("Book_ID")
);
CREATE TABLE "review" (
"Review_ID" int,
"Book_ID" int,
"Rating" real,
"Readers_in_Million" real,
"Rank" int,
PRIMARY KEY ("Review_ID"),
FOREIGN KEY ("Book_ID") REFERENCES `book`("Book_ID")
);
INSERT INTO  "book" VALUES (1,"A Game of Thrones","Novel","704","73","33h 53m","August 1996");
INSERT INTO  "review" VALUES (1,1,"6.6","3.3","16");