Question 7 - 100% Working Solution | Buy Now

Description

Oldest Book per Genre You have been provided with two tables, library_books and book_genres, containing information about books and their corresponding genres. Write an SQL query to find the oldest book (based on publication_year) in each genre. If there are multiple books with the same publication year in a genre, return the one that appears first alphabetically by title. Table description Input format Table: library_books book_id, int, Represents the unique ID of the book book_title, string, Represents the title of the book genre_ld, int, Represents the ID of the genre of the book
Question Image

All Testcases Passed ✔



Passcode Image

Solution

Please login to view the solution