{"author_name":"trhnmr","url":"https://qe.hpeo.jp/entry/ipa-db/e09h09","provider_name":"Hatena Blog","author_url":"https://blog.hatena.ne.jp/trhnmr/","version":"1.0","title":"DB \u5e73\u621021\u5e74\u5ea6\u6625\u671f \u554f9","categories":["\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30b9\u30da\u30b7\u30e3\u30ea\u30b9\u30c8"],"height":"190","blog_url":"https://qe.hpeo.jp/","provider_url":"https://hatena.blog","image_url":"https://cdn-ak.f.st-hatena.com/images/fotolife/t/trhnmr/20220517/20220517151055.png","published":"2023-04-25 15:11:26","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fqe.hpeo.jp%2Fentry%2Fipa-db%2Fe09h09\" title=\"DB \u5e73\u621021\u5e74\u5ea6\u6625\u671f \u554f9 - \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>","type":"rich","description":"\u201c\u793e\u54e1\u201d\u8868\u3068\u201c\u4eba\u4e8b\u7570\u52d5\u201d\u8868\u304b\u3089\u793e\u54e1\u3054\u3068\u306e\u52e4\u52d9\u6210\u7e3e\u306e\u5e73\u5747\u3092\u6c42\u3081\u308b\u9069\u5207\u306aSQL\u6587\u306f\u3069\u308c\u304b\u3002\u3053\u3053\u3067\uff0c\u6c42\u3081\u308b\u9805\u76ee\u306f\uff0c\u793e\u54e1\u30b3\u30fc\u30c9\uff0c\u793e\u54e1\u540d\uff0c\u52e4\u52d9\u6210\u7e3e\uff08\u5e73\u5747\uff09\u306e3\u9805\u76ee\u3068\u3059\u308b\u3002 SELECT \u793e\u54e1.\u793e\u54e1\u30b3\u30fc\u30c9, \u793e\u54e1\u540d, AVG(\u52e4\u52d9\u6210\u7e3e) AS \"\u52e4\u52d9\u6210\u7e3e(\u5e73\u5747)\" FROM \u793e\u54e1, \u4eba\u4e8b\u7570\u52d5 WHERE \u793e\u54e1.\u793e\u54e1\u30b3\u30fc\u30c9 = \u4eba\u4e8b\u7570\u52d5.\u793e\u54e1\u30b3\u30fc\u30c9 GROUP BY \u52e4\u52d9\u6210\u7e3e SELECT \u793e\u54e1.\u793e\u54e1\u30b3\u30fc\u30c9, \u793e\u54e1\u540d, AVG(\u52e4\u52d9\u6210\u7e3e) AS \"\u52e4\u52d9\u6210\u7e3e(\u5e73\u5747)\" FROM \u793e\u54e1, \u4eba\u4e8b\u7570\u52d5 WHERE \u793e\u54e1.\u793e\u54e1\u30b3\u30fc\u30c9 = \u4eba\u4e8b\u7570\u52d5.\u793e\u54e1\u30b3\u30fc\u30c9 GROUP BY \u793e\u54e1.\u793e\u54e1\u30b3\u30fc\u30c9, \u793e\u54e1.\u793e\u54e1\u540d SEL\u2026","blog_title":"\u8cc7\u683c\u90e8"}