Skip to content

Instantly share code, notes, and snippets.

@hashcc

hashcc/example.sql Secret

Created November 1, 2021 00:38
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/c6bde7a3d7c76f7e8ca792f4843d2470 to your computer and use it in GitHub Desktop.
Save hashcc/c6bde7a3d7c76f7e8ca792f4843d2470 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
example.sql
select
ユーザーID,
count(レシピID) as レシピ投稿数
from
recipes
group by
ユーザーID
order by
レシピ投稿数 desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment