Skip to content

Instantly share code, notes, and snippets.

@hashcc

hashcc/example.sql Secret

Created October 31, 2021 17:26
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/00ff4214dc9cfca16d828db68b9d7555 to your computer and use it in GitHub Desktop.
Save hashcc/00ff4214dc9cfca16d828db68b9d7555 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