This is the Question
We've created a database of a few popular authors and their books, with word counts for each book. In this first step, select all the authors who have written more than 1 million words, using GROUP BY and HAVING. Your results table should include the 'author' and their total word count as a 'total_words' column.
This is code I am using , but this is not moving to next question . What's wrong with my Queary
SELECT author,SUM(words) AS total_words FROM books GROUP BY author HAVING total_words > 100000;