Skip to content

Instantly share code, notes, and snippets.

@hashcc

hashcc/example.sql Secret

Created November 1, 2021 00:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hashcc/53bb846f1d5c1b64cd2d2cd180761412 to your computer and use it in GitHub Desktop.
Save hashcc/53bb846f1d5c1b64cd2d2cd180761412 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
example.sql
select
recipes.ユーザーID,
count(レシピID) as レシピ投稿数,
tsukurepos.つくれぽ投稿数
from
recipes
full join
tsukurepos
on
recipes.ユーザーID = tsukurepos.ユーザーID
group by
ユーザーID
order by
ユーザーID
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment