How to display the most popular product category?

Question

SQL

I practice here: www.w3schools.com/sql/trysql.asp?filename=trysql_s...
How to display the most popular category?
Which has the largest number of products.
Stopped here:

SELECT c.CategoryName,c.CategoryID
FROM [Categories] c
INNER JOIN Products p ON c.CategoryID = p.CategoryID

Answer 1

SELECT c.*, COUNT(1) as cnt FROM Categories as c
LEFT JOIN products as p ON c.CategoryID = p.CategoryID
GROUP by p.CategoryID
ORDER BY cnt DESC

add LIMIT 1 if you want to leave only with the maximum amount