🎁 Exclusive Offer! Join our
Telegram Channel
to get **special discounts** and updates! 🚀
Question 7 - 100% Working Solution | Buy Now
Description
9 Live
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