Question: Hello! Based on the following SQL code I have pasted below, you are to find: Which authors have written more than 10 reviewed books? List
Hello! Based on the following SQL code I have pasted below, you are to find:
Which authors have written more than 10 reviewed books?
List the author login and number of books. List them with the largest count first; in case of ties on count put them in alphabetical order by login. Only include books with the reviewed flag equal 1.
create table Reads (-- a record for each book that was read time date, ip integer, bid integer, foreign key (bid) references Books, foreign key (ip) references Locations) time the book was read --ip of the computer book id create table Books ( bid integer primary key, title text, aid integer, reviewed integer, foreign key (aid) references Authors) -- author id -1 if the book is reviewed, 0 otherwise create table Locations ( ip integer primary key, -- ip address of the computer country text) - country determined from the ip address create table Authors aid integer primary key, login text, birthday text) -- month and day of the author's birthday like May 29 User id like Gary
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts

