example.sql

with

recipes_count as (
select
  ユーザーID,
  count(レシピID) as レシピ投稿数
from
  recipes
group by
  ユーザーID
order by
  レシピ投稿数 desc
),

...
--（中略）
...

select
  *
from
  recipes_count