Challenge: The wordiest author

Step 1

Hint

SELECT … FROM … GROUP BY … HAVING …;

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
HAVING. Your results table should include the 'author' and their total word count as a 'total_words' column.