クリエイターさんが関わったブランドのクリエイター別解散数の実行結果

SQLの説明

検索結果

実行したSQL

      SELECT '<a href="creater.php?creater=' || t.id || '">' ||  t.name || '</a>'  AS クリエイター名 , COUNT(*) AS 解散ブランド数 FROM ( SELECT c.id , c.name , b.id  AS brand_id FROM createrlist c , gamelist g , shokushu s , brandlist b WHERE c.id = s.creater AND b.id = g.brandname AND g.id = s.game AND b.lost = TRUE GROUP BY c.id , c.name , b.id ) AS t GROUP BY t.id , t.name ORDER BY COUNT(*) DESC LIMIT 500;