{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Ftoshi33-rails-docker.hatenadiary.jp%2Fentry%2F2022%2F08%2F05%2F144857\" title=\"SQL\u554f\u984c(22/08/05) - toshizou-Rails\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2022-08-05 14:48:57","height":"190","blog_title":"toshizou-Rails","categories":["SQL","LeetCode"],"version":"1.0","url":"https://toshi33-rails-docker.hatenadiary.jp/entry/2022/08/05/144857","author_url":"https://blog.hatena.ne.jp/asdfghtresxc/","blog_url":"https://toshi33-rails-docker.hatenadiary.jp/","title":"SQL\u554f\u984c(22/08/05)","provider_url":"https://hatena.blog","provider_name":"Hatena Blog","description":"\u554f\u984c\u30ea\u30f3\u30af https://leetcode.com/problems/game-play-analysis-i/ \u81ea\u5206\u306e\u66f8\u3044\u305f\u30b3\u30fc\u30c9 \u4ee5\u4e0b\u306f\u53c2\u8003\u306b\u3057\u305f\u30ea\u30f3\u30af MySQL | \u30c7\u30fc\u30bf\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3059\u308b(GROUP BY\u53e5) SQL\u3067\u540c\u4e00\u30b0\u30eb\u30fc\u30d7\u306e\u4e2d\u3067\u6700\u5927/\u6700\u5c0f\u306e\u30ec\u30b3\u30fc\u30c9\u3092\u53d6\u5f97\u3059\u308b - Qiita\u89e3\u7b54\u7684\u306b\u306fok\u3002 SELECT player_id, min(event_date) AS first_login FROM Activity GROUP BY player_id \u3067\u3082\u30d1\u30d5\u30a9\u30fc\u30de\u30f3\u30b9\u304c\u60aa\u3044\u3088\u3046\u306b\u611f\u3058\u308b... Runtime: 1289 ms, faster than 7.13% of M\u2026","author_name":"asdfghtresxc","type":"rich","width":"100%","image_url":null}