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.

Hello! Based on the following SQL code I have pasted below, you

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!