Skip to content

Instantly share code, notes, and snippets.

@hashcc

hashcc/example.sql Secret

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