{"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fqe.hpeo.jp%2Fentry%2Fipa-fe%2Fe19a26\" title=\"FE \u4ee4\u548c\u5143\u5e74\u5ea6\u79cb\u671f \u554f26 - \u8cc7\u683c\u90e8\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/t/trhnmr/20220614/20220614134730.png","type":"rich","width":"100%","provider_name":"Hatena Blog","blog_title":"\u8cc7\u683c\u90e8","description":"\u201c\u5f97\u70b9\u201d\u8868\u304b\u3089\uff0c\u5b66\u751f\u3054\u3068\u306b\u5168\u79d1\u76ee\u306e\u70b9\u6570\u306e\u5e73\u5747\u3092\u7b97\u51fa\u3057\uff0c\u5e73\u5747\u304c80\u70b9\u4ee5\u4e0a\u306e\u5b66\u751f\u306e\u5b66\u751f\u756a\u53f7\u3068\u305d\u306e\u5e73\u5747\u70b9\u3092\u6c42\u3081\u308b\u3002a\u306b\u5165\u308c\u308b\u9069\u5207\u306a\u5b57\u53e5\u306f\u3069\u308c\u304b\u3002\u3053\u3053\u3067\uff0c\u5b9f\u7dda\u306e\u4e0b\u7dda\u306f\u4e3b\u30ad\u30fc\u3092\u8868\u3059\u3002 \u5f97\u70b9\uff08\u5b66\u751f\u756a\u53f7\uff0c\u79d1\u76ee\uff0c\u70b9\u6570\uff09 \u3014SQL\u6587\u3015 SELECT \u5b66\u751f\u756a\u53f7, AVG(\u70b9\u6570) FROM \u5f97\u70b9 GROUP BY a \u79d1\u76ee HAVING AVG(\u70b9\u6570) >= 80 \u79d1\u76ee WHERE \u70b9\u6570 >= 80 \u5b66\u751f\u756a\u53f7 HAVING AVG(\u70b9\u6570) >= 80 \u5b66\u751f\u756a\u53f7 WHERE \u70b9\u6570 >= 80 \u89e3\u7b54\u30fb\u89e3\u8aac \u89e3\u7b54 \u30a6 \u89e3\u8aac \u30b0\u30eb\u30fc\u30d7\u5316\u306e\u5358\u4f4d\u306f\u201c\u5b66\u751f\u201d\u306e\u305f\u3081\u3001GROUP BY \u306e\u5f8c\u306b\u306f \u300c\u5b66\u751f\u756a\u53f7\u300d\u306b\u306a\u308a\u307e\u3059\u3002 \u307e\u305f\u3001GR\u2026","author_url":"https://blog.hatena.ne.jp/trhnmr/","url":"https://qe.hpeo.jp/entry/ipa-fe/e19a26","provider_url":"https://hatena.blog","blog_url":"https://qe.hpeo.jp/","categories":["\u57fa\u672c\u60c5\u5831\u6280\u8853\u8005"],"title":"FE \u4ee4\u548c\u5143\u5e74\u5ea6\u79cb\u671f \u554f26","height":"190","author_name":"trhnmr","published":"2023-05-04 00:00:00","version":"1.0"}