SQL intermediate Class - Number of Books

Question

can anyone help me

SELECT Authors.name, COALESCE(COUNT(Books.name), 0)AS books
FROM Books RIGHT JOIN Authors ON Authors.id = Books.author_id GROUP BY Authors.id, Authors.name
ORDER BY books DESC

Answer 1

SELECT Authors.name, COALESCE(COUNT(Books.name), 0) AS books
FROM Authors
LEFT JOIN Books ON Authors.id = Books.author_id
GROUP BY Authors.id, Authors.name
ORDER BY books DESC;

Answer 2

Tibor Santa

So if try this, it will work?

SELECT Authors.name, COALESCE(COUNT(Books.name), 0)AS books
FROM Books RIGHT JOIN Authors ON Authors.id = Books.author_id GROUP BY Authors.name
ORDER BY books DESC

Answer 3

https://api2.sololearn.com/v2/certificates/CT-BTI2TWWE/image/png

Answer 4

I try this and didnt work Kelvin Kaloki Muema

Answer 5

Your select clause must contain all the fields which are listed in the group by clause.

Answer 6

Bruna Yukimy Hada why don't you try?
It looks syntactically correct, but I don't know if this answers the specific task.

Answer 7

It works tks guys