May 20th, 2016 by Per Thykjaer Jensen
So how do yo find the most popular cake in the Shire Bakery? Here’s an idea.
-- 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