Answered You can hire a professional tutor to get the answer.
Hi, I am stuck on doing COUNT() in sql, I'm using sqlite The question is "Display the first name and last name of authors who wrote more than 3 books....
Hi, I am stuck on doing COUNT() in sql, I'm using sqlite
The question is "Display the first name and last name of authors who wrote more than 3 books. Along with
each name, display the number of books as well."
It it for a library database.
The database schema is as follows
borrow(transactionID, personID*, borrowdate, duedate, returndate)
author(authorID, firstname, middlename, lastname)
book_copy(bookID, bookdescID*)
book(bookdescID, title, subtitle, edition, voltitle, volnumber, language, place, year, isbn, dewey, subjectID*)
borrow_copy(transactionID*, bookID*)
person(personID, firstname, middlename, lastname, address, city, postcode, phonenumber, emailaddress, studentno, idcardno)
publisher(publisherID, publisherfullname)
written_by(bookdescID*, authorID*, role)
published_by(bookdescID*, publisherID*, role)
subject(subjectID, subjecttype)
