Company: Bny_1march
Difficulty: medium
Problem Description Write an SQL query to find the oldest book in each genre, based on its publication_year . If there are multiple books within the same genre that share the oldest publication year, resolve the tie by returning the book whose book_title appears first alphabetically. Schema Table: library_books Column Name Type Description book_id INT Represents the unique ID of the book. book_title VARCHAR Represents the title of the book. genre_id INT Represents the ID of the genre of the book. book_rating INT Represents the rating of the book (on a scale of 1 to 10). publication_year INT Represents the year when the book was published. Table: book_genres Column Name Type Description genre_id INT Represents the unique ID of the genre. genre_name VARCHAR Represents the name of the genre. Required Output Your query should return the genre name and the corresponding oldest book title. The order of the returned rows does not matter. Column Name Type Description genre_name VARCHAR The nam