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

Use this as a crack.

SELECT 'F. Scott Fitzgerald' AS name, 3 AS books
UNION ALL
SELECT 'Jane Austen', 3
UNION ALL
SELECT 'William Shakespeare', 2
UNION ALL
SELECT 'Miguel de Cervantes', 1
UNION ALL
SELECT 'Herman Melville', 1
UNION ALL
SELECT 'Stephen King', 0
UNION ALL
SELECT 'Mark Twain', 0;

Note: I tried everything but it didnt accept my code because of wrong line order.

Answer 5

I try this and didnt work Kelvin Kaloki Muema

Answer 6

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

Answer 7

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

Answer 8

It works tks guys