SQL Intermediate Practice Question

Question

Need help with SQL Intermediate Practice question Number of Books

How do I get the null records to show with the other records

SELECT A.name, COUNT (B.id) AS books
FROM Authors AS A JOIN Books AS B
ON A.id= B.author_id
GROUP BY A.name, B.id
ORDER BY A.name ASC, B.id DESC

Answer 1

Danielle Strahan the question states 0 as count not " null " which represents there is nothing there ... 0 is a number

SELECT A.name, count(B.id) as books

FROM Books AS B RIGHT JOIN Authors AS A ON B.author_id = A.id

GROUP By A.name

ORDER By books desc

example 1:
SELECT product_id FROM products WHERE quantity = 0;
example 2:
SELECT product_id FROM products WHERE price IS NULL;

Answer 2

If interested in sql tutoral kindly join the group
https://chat.whatsapp.com/BENIJjgKOK10SXry1Cipm3