Ranking escape roomów: 106 nagrodzonych pokoi z 1 lat

SELECT p.name, count(DISTINCT r.id)
FROM providers p JOIN locations l ON l.provider_id = p.id
JOIN rooms r ON r.location_id = l.id
WHERE p.status = 'active' AND l.status = 'active' AND r.status = 'active'
  AND l.country = 'DE'
GROUP BY p.name ORDER BY 2 DESC LIMIT 25

… GROUP BY p.name HAVING count(DISTINCT l.id) > 1 ORDER BY 2 DESC

… GROUP BY l.id ORDER BY count(DISTINCT r.id) DESC

… GROUP BY l.city, l.country ORDER BY count(DISTINCT r.id) DESC

… , unnest(r.genre) g GROUP BY l.city, l.country ORDER BY count(DISTINCT g) DESC

… WHERE r.duration_minutes IS NOT NULL ORDER BY r.duration_minutes DESC