如何显示每位作者每年出版的书籍数量

I'm having trouble with this question: Show the number of books published each year by each author. Show only the rows for author who published more than 1 book in a year. The table should show author, Pubyear, and “Total Book Published in Year”. MediaID should not be used in this query, use MediaCode.I'm having trouble with this question: Show the