SQL queries in MySQL

Query 9. List complete information about the most recent published book in the database.

ISBN Title Year Edition

Query 10. List complete information about the earliest published book in the database.

ISBN Title Year Edition

Query 11. List complete information about the second oldest book in the database.

ISBN Title Year Edition

Query 12. In the descending order of year published, list complete information of all books in the database along with the corresponding author information.

ISBN Title Year Edition Author Last Name Author First Name

Query 13. In the descending order of year published first and then the descending order of edition within the year, list complete information of all books that were written by William Stallings.

ISBN Title Year Edition

Query 14. List complete information about every book in the database along with the number of authors who wrote the book

ISBN Title Year Edition Number of Authors

Author Columns New A ID Frame Lname Indexes A writes B Columns New A ID Lui ISBN Indexes Book Columns A New Edition II ISBN Title Year Indexes Author Columns New A ID Frame Lname Indexes A writes B Columns New A ID Lui ISBN Indexes Book Columns A New Edition II ISBN Title Year Indexes