Skip to content

Instantly share code, notes, and snippets.

@hashcc

hashcc/example.sql Secret

Last active October 31, 2021 17:27
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/a2ab1a777bdb7f606809a25aec101f3e to your computer and use it in GitHub Desktop.
Save hashcc/a2ab1a777bdb7f606809a25aec101f3e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
example.sql
select
users.ユーザーID,
ニックネーム,
登録日時
count(レシピID) as レシピ投稿数
from
recipes
join
users
on
recipes.ユーザーID = users.ユーザーID
group by
ユーザーID
order by
レシピ投稿数 desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment