SQLでサブクエリに名前をつける

WITH句を使う。

-- 名前付け
with name as (
 --サブクエリ
 select * from XXX
 join XXXX on BBB = AAA
 where aa = cc 
)

, name2 as (
   --サブクエリ
   select * from XXX
   join XXXX on BBB = AAA
   group by 
   having count(*) >= num
)

--呼び出し
select * from name 
join name2 on xxx =xxx ;

複雑なクエリだと、with使うと読みやすくなりますね。