example.sql

with

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

tsukurepos_count as (
select
  ユーザーID,
  count(つくれぽID) as つくれぽ投稿数
from
  tsukurepos
group by
  ユーザーID
order by
  つくれぽ投稿数 desc
)