Learning SQL - what am I doing wrong on this challenge???

Qanday yordam kerak?

Jessica Evans

March 10, 2024 04:39

Task is to figure out which author has written over 1 million words. Here is what I wrote, and I'm pretty sure it is correct (I have also found other peoples answers on google and they match mine, but the next step is greyed out..)

SELECT author, SUM(words) AS total_words FROM books GROUP BY author;

SELECT author, SUM(words)
AS total_words
FROM books
GROUP BY author
HAVING total_words > 1000000

Yangi maqola

1 sharh

AD Baker

March 19, 2024 11:51
0

Sharhlar bilan harakatlar Doimiy havola
For Step 1 of the Wordiest Author Challenge, you only need one SELECT statement. Your second statement here looks correct, except it is missing the final ; Try deleting the first statement and see whether you pass Step 1.

Remember that the auto-grader looks for very specific code. If you want to experiment, write any additional code at the end of the challenge, after you have written all of the code to pass the challenge.

sharhsiz qoldirish uchu Xizmatga kiring

Learning SQL - what am I doing wrong on this challenge???

Qidirayotgan narsangizni topdingizmi?

1 sharh

Qidirayotgan narsangizni topdingizmi?