{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fknknkn.hatenablog.com%2Fentry%2F2018%2F05%2F05%2F164824\" title=\"SQL\u3067\u9023\u7d9a\u8ab2\u91d1\u65e5\u6570\u3092\u8a08\u7b97\u3057\u3001\u305d\u306e\u6700\u5927\u5024\u3092\u6c42\u3081\u308b - \u307e\u305a\u306f\u874b\u306e\u7ffc\u304b\u3089\u3002\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","published":"2018-05-05 16:48:24","height":"190","categories":["SQL"],"blog_url":"https://knknkn.hatenablog.com/","author_url":"https://blog.hatena.ne.jp/chito_ng/","url":"https://knknkn.hatenablog.com/entry/2018/05/05/164824","author_name":"chito_ng","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/c/chito_ng/20180505/20180505151641.png","blog_title":"\u307e\u305a\u306f\u874b\u306e\u7ffc\u304b\u3089\u3002","type":"rich","provider_url":"https://hatena.blog","version":"1.0","provider_name":"Hatena Blog","title":"SQL\u3067\u9023\u7d9a\u8ab2\u91d1\u65e5\u6570\u3092\u8a08\u7b97\u3057\u3001\u305d\u306e\u6700\u5927\u5024\u3092\u6c42\u3081\u308b","width":"100%","description":"\u30e6\u30fc\u30b6\u30fc\u6bce\u306e\u6700\u9577\u9023\u7d9a\u8ab2\u91d1\u65e5\u6570\u3092\u6c42\u3081\u308b\u3002 Redshift\u3092\u60f3\u5b9a\u3002 \u30c7\u30fc\u30bf\u30a4\u30e1\u30fc\u30b8 \u300c\u8ab2\u91d1\u300d\u5217\u306f\u305d\u306e\u65e5\u8ab2\u91d1\u3057\u305f\u5834\u5408\u306f1\u3001\u8ab2\u91d1\u3057\u3066\u306a\u304b\u3063\u305f\u5834\u5408\u306f0\u3068\u306a\u308b\u3002 \u300e\u9023\u7d9a\u3057\u3066\u25cb\u25cb\u3057\u305f\u65e5\u6570\u300f\u3092\u3069\u3046\u3084\u3063\u3066SQL\u3067\u6c42\u3081\u308b\u304b\uff1f\u304c\u30dd\u30a4\u30f3\u30c8\u3068\u306a\u308a\u307e\u3059\u3002 SQL\u306a\u306e\u3067\u3001\u96c6\u7d04\u95a2\u6570\u3084WINDOW\u95a2\u6570\u306a\u3069\u3092\u4f7f\u3048\u3070\u7c21\u5358\u306b\u9023\u7d9a\u3057\u305f\u65e5\u6570\u3092\u8a08\u7b97\u3067\u304d\u308b\u3068\u601d\u3044\u304d\u3084\u3001 SUM\u95a2\u6570\u3092\u4f7f\u304a\u3046\u306b\u3082\u3001\u4e0b\u56f3\u306e\u3088\u3046\u306b\u3001\u300c\u540c\u3058user_id\u300d\u304b\u3064\u300c\u9023\u7d9a\u3057\u3066\u3044\u308b\u65e5\u300d\u3092\u96c6\u8a08\u9818\u57df\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u3001\u6848\u5916\u982d\u3092\u4f7f\u3063\u305f\u3002 \u30dd\u30a4\u30f3\u30c8 \u300c\u540c\u3058user_id\u3067\u8ab2\u91d1\u65e5\u304c\u9023\u7d9a\u3057\u3066\u3044\u308b\u300d\u90e8\u5206\u3092\u96c6\u8a08\u9818\u57df\u306b\u3057\u305f\u96c6\u8a08\u95a2\u6570\u3092\u4f7f\u3046\u3002 \u305d\u306e\u305f\u3081\u306b\u3001\u300c\u540c\u3058user_id\u300d\u304b\u3064\u300c\u8ab2\u91d1\u3057\u3066\u3044\u308b\u65e5\u2026"}