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
Asked in: No companies listed
Image of the Question
All Testcases Passed ✔
