아경

<p>감사합니다. 선생님, 저의 원래 질문 의도는 방출되지 않은(status IN("Active", "Training") 포켓몬의 type1, kor_name, 포켓몬의 수를 구하고 싶었습니다!</p><p>선생님 말씀대로라면 아래 쿼리처럼 하면 될까요??</p><pre><code>WITH results_release_pokemon AS (
  SELECT
  p.type1,
  tp.status,
  p.kor_name,
  COUNT(tp.id) AS cnt,
  CASE WHEN status IN("Active", "Training") THEN "no_released"
  ELSE "released"
  END AS result_release_pokemon
FROM basic.trainer_pokemon AS tp
LEFT JOIN basic.pokemon as p
ON tp.pokemon_id = p.id
GROUP BY
  p.type1,
  tp.status,
  p.kor_name
ORDER BY
  cnt DESC
)
SELECT
  type1,
  kor_name,
  cnt
FROM results_release_pokemon AS rrp
WHERE
  result_release_pokemon = "no_released"</code></pre>

아경

게시글