This post contiues the SQL tutorial on the Shire Bakery. Here we’llThe Most Popular Cake in the Shire Bakery

So how do yo find the most popular cake in the Shire Bakery? Here’s an idea.

PhpMyAdmin: the most popular caske

-- Show the best cookie
-- See: Ben Forta Chap. 16
SELECT COUNT( cakes.cake ) AS 'popular', cakes.cake, costumers.who
FROM cakes, costumers, likes
-- sort out the cardinalities (relations)
WHERE cakes.cakes_id = likes.cakes_id
AND costumers.costumers_id = likes.costumers_id
-- group by the cake
group by cakes.cake
-- and sort (most popular and downwards)
order by popular desc