🎁 Exclusive Offer! Join our Telegram Channel to get **special discounts** and updates! 🚀

🚀 Struggling with coding interviews? We've got you covered! 💡 Practice real questions, sharpen your skills, and land your dream job! 🎯
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

Asked in: No companies listed

Image of the Question

Question Image

All Testcases Passed ✔



Passcode Image

Solution


Please login to view the solution