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
Per Thykjaer Jensen
Author and Senior Lecturer at the Multimedia Design AP Programme. MA Literature History, BA Art History, MA IT, interaction and Multimedia. WordPress user since 2007. Whatever you read here is my personal point of view.
Multimusen.dk will set a few cookies from Doubleclick, Google and the Social Media plugins they ay set some cookies. Some of my pages use APIs - such as YouTube, LinkedIn, Google Fonts, Google Maps, Mapbox, Spotify, Jetpack, Twitter, Facebook &c.. Such plugins may set the odd cookie.
Leave a Reply