SQL Interview Question 2024 | Find books published in the last year and corresponding authors

[@madhusudhanreddyt2838]

IN SQL SERVER (SSMS) -- List all authors and number of books written select a.AuthorName, COUNT(b.BookID) as [Number of Books] from Authors as a LEFT OUTER JOIN Books as b on a.AuthorID = b.AuthorID group by a.AuthorName order by a.AuthorName; -- Find books published in the last year and corresponding authors select b.BookTitle, a.AuthorName, YEAR(b.PublicationYear) as PublicationYear, YEAR(GETDATE()) as CurrentYear, YEAR(GETDATE()) - 1 as LastYear from Authors as a inner join Books as b on a.AuthorID = b.AuthorID where YEAR(b.PublicationYear) = YEAR(GETDATE()) - 1; happy quering :)