结构化查询语言SQL解析

% E7 % AC % AC % E5 % 9b % E7 % ab % A0 % 20 % E7 % bb % 93 % E6 % 84 % E5 % 8c % 96 % E6 % 9f % a5 % E8 % af % a2 % 25 % 2095 % 94 % A8 % ef % BC % 9b % E2 % 96 % ba % 20 % E6 % 8c % E6 % 8f % E5 % ba % E6 % 9c % E8 % A8 % E7 % 20 % 8e % E5 % 88 % A0 % 5 % ae9 % B9 % E7 % 9a % 84 % E6 % 8f % 92 % E5 % a5 % E3 % 80 % 81 % E4 % BF % ae6 % 96 % 25 % 20f % E4 % b8 % BD % 9c % % BD % E4 % bb % a4 % A0 % BC % E5 % BC % 8f % E4 % b8 % E4 % 25 % 209 f % a5 % E8 % af % a2 % E8 % af % ad % E5 % 8f % a5 E6 % 9f % a5 % E8 % af % a2 % E8 % a6 % E6 % B1 % 82 % E5 % 86 % E5 % 87 % 20 SQL % E8 % af % ad % E8 % 80 % E7 % 9a % 84 ef % BC % 89 % E7 % 9a % 84 % E7 % BC % a9 % E5 % 86 % ef % BC % 8c % E5 % 85 % B7 % E6 % 9c % 20 % E6 % 95 % B0 % E6 % 8d % AC af % a2 % E5 % 9b % E4 % b8 % aa % e9 % 83 % A8 % E5 % 86 % E3 % 80 % 82 SQL % E6 % B0 % E6 % 20e % 9a % E4 % B9 % E6 % B0 % E6%9A%E8%A7%86%E5%9B%BE%EF%BC%88View%EF%BC%89%EF%BC%8C%E5%85%A8%E5%B1%80%E6%A8%A1%E5%BC%8F%E7%AE%80%E7%A7%B0%E6%A8%A1%E5%BC%8F%EF%BC%88Schema%EF%BC%89%E6%88%96%E6%95%B0%E6%8D%AE%E5%BA%93%EF%BC%88Database%EF%BC%89%EF%BC%8C%E5%86%85%E6%A8%A1%E5%BC%8F%E7%94%B1%E7%B3%BB%E7%BB%9F%E6%A0%B9%E6%8D%AE%E6%95%B0%E6%8D%AE%E5%BA%93%E6%A8%A1%E5%BC%8F%E8%87%AA%E5%8A%A8%E5%AE%9E%E7%8E%B0%EF%BC%8C%E4%B8%80%E8%88%AC%E6%97%A0%E9%9C%80%E7%94%A8%E6%88%B7%E8%BF%87%E9%97%AE%E3%80%82%E5%9F%BA%E6%9C%AC%E8%A1%A8%EF%BC%88%E8%A1%A8%EF%BC%89%E3%80%81%E5%B1%9E%E6%80%A7%EF%BC%88%E5%AD%97%E6%AE%B5%EF%BC%89%E3%80%81%E5%85%83%E7%BB%84%EF%BC%88%E8%A1%8C%EF%BC%89%E7%9A%84%E6%A6%82%E5%BF%B5SQL%E6%95%B0%E6%8D%AE%E6%93%8D%E7%BA%B5%E5%8A%9F%E8%83%BD%EF%BC%9A%E5%8C%85%E6%8B%AC%E5%AF%B9%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%92%8C%E8%A7%86%E5%9B%BE%E7%9A%84%E6%95%B0%E6%8D%AE%E6%9F%A5%E8%AF%A2%E3%80%81%E6%8F%92%E5%85%A5%E3%80%81%E5%88%A0%E9%99%A4%E5%92%8C%E4%BF%AE%E6%94%B9%EF%BC%8C%E7%89%B9%E5%88%AB%E6%98%AF%E5%85%B7%E6%9C%89%E5%BE%88%E5%BC%BA%E7%9A%84%E6%95%B0%E6%8D%AE%E6%9F%A5%E8%AF%A2%E5%8A%9F%E8%83%BD%E3%80%82SQL%E7%9A%84%E6%95%B0%E6%8D%AE%E6%8E%A7%E5%88%B6%E5%8A%9F%E8%83%BD%EF%BC%9A%E4%B8%BB%E8%A6%81%E6%98%AF%E5%AF%B9%E7%94%A8%E6%88%B7%E7%9A%84%E8%AE%BF%E9%97%AE%E6%9D%83%E9%99%90%E5%8A%A0%E4%BB%A5%E6%8E%A7%E5%88%B6%EF%BC%8C%E4%BB%A5%E4%BF%9D%E8%AF%81%E7%B3%BB%E7%BB%9F%E7%9A%84%E5%AE%89%E5%85%A8%E6%80%A7%E3%80%82%0ASQL%0A%E8%A7%86%E5%9B%BEV1%20%E8%A7%86%E5%9B%BEV2%0A%E5%9F%BA%E6%9C%AC%E8%A1%A8B1%20%E5%9F%BA%E6%9C%AC%E8%A1%A8B2%20%E5%9F%BA%E6%9C%AC%E8%A1%A8B3%20%E5%9F%BA%E6%9C%AC%E8%A1%A8B4%E5%88%86%E5%8C%BA1%E6%96%87%E4%BB%B61%20%E6%96%87%E4%BB%B62%E5%88%86%E5%8C%BA2%0A%E6%96%87%E4%BB%B63%20%E6%96%87%E4%BB%B64%E5%A4%96%E6%A8%A1%E5%BC%8F%E6%A8%A1%E5%BC%8F%0A%E5%AD%98%E5%82%A8%E6%A8%A1%E5%BC%8F%0ASQL%E6%94%AF%E6%8C%81%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E7%9A%84%E4%BD%93%E7%B3%BB%E7%BB%93%E6%9E%84%E4%B8%80%E3%80%81%E6%95%B0%E6%8D%AE%E5%BA%93%E6%A8%A1%E5%BC%8F%E7%9A%84%E5%BB%BA%E7%AB%8B%E5%92%8C%E5%88%A0%E9%99%A41%E3%80%81%E5%BB%BA%E7%AB%8B%E6%95%B0%E6%8D%AE%E5%BA%93%E6%A8%A1%E5%BC%8F%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0ACREATE%20SCHEMA%7CDATABASE%20%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E%20%5BAUTHORIZATION%20%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E%5D%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%E5%9C%A8%E8%AE%A1%E7%AE%97%E6%9C%BA%E7%B3%BB%E7%BB%9F%E4%B8%AD%E5%BB%BA%E7%AB%8B%E4%B8%80%E4%B8%AA%E5%8F%AA%E6%9C%89%E5%90%8D%E5%AD%97%E7%9A%84%E7%A9%BA%E6%95%B0%E6%8D%AE%E5%BA%93%EF%BC%8C%E5%B9%B6%E5%AE%9A%E4%B9%89%E5%87%BA%E5%AE%83%E7%9A%84%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%E3%80%82%0A%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9A%0A%EF%BC%881%EF%BC%89create%20schema%20xuesh%20authorization%20%E5%88%98%E5%8B%87%EF%BC%882%EF%BC%89%20create%20database%20%E6%95%B0%E6%8D%AE%E5%BA%932%E3%80%81%E5%88%A0%E9%99%A4%E6%95%B0%E6%8D%AE%E5%BA%93%E6%A8%A1%E5%BC%8F%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0ADROP%20SCHEMA%7CDATABASE%20%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%0A%E4%BB%8E%E8%AE%A1%E7%AE%97%E6%9C%BA%E7%B3%BB%E7%BB%9F%E4%B8%AD%E5%88%A0%E9%99%A4%EF%BC%88%E6%92%A4%E9%94%80%EF%BC%89%E4%B8%80%E4%B8%AA%E6%95%B0%E6%8D%AE%E5%BA%93%E3%80%82%E5%BD%93%E7%84%B6%E4%BC%9A%E5%90%8C%E6%97%B6%E6%8A%8A%E8%AF%A5%E5%BA%93%E4%B8%AD%E7%9A%84%E6%89%80%E6%9C%89%E4%BF%A1%E6%81%AF%E4%B8%80%E5%B9%B6%E5%88%A0%E9%99%A4%E6%8E%89%E3%80%82%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9Adrop%20database%20xuesh%E4%BA%8C%E3%80%81%E8%A1%A8%E7%BB%93%E6%9E%84%E7%9A%84%E5%BB%BA%E7%AB%8B%E3%80%81%E4%BF%AE%E6%94%B9%E5%92%8C%E5%88%A0%E9%99%A41%E3%80%81%E5%BB%BA%E7%AB%8B%E8%A1%A8%E7%BB%93%E6%9E%84%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0ACREATE%20TABLE%20%5B%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E.%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E.%5D%20%3C%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%90%8D%3E%20%EF%BC%88%3C%E5%88%97%E5%AE%9A%E4%B9%89%3E%EF%BC%8C%E2%80%A6%E2%80%A6%5B%2C%3C%E6%A0%87%E8%AE%B0%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%3E%2C%E2%80%A6%E2%80%A6%5D%29%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%E5%9C%A8%E5%BD%93%E5%89%8D%E6%88%96%E7%BB%99%E5%AE%9A%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%AE%9A%E4%B9%89%E4%B8%80%E4%B8%AA%E8%A1%A8%E7%9A%84%E7%BB%93%E6%9E%84%EF%BC%88%E5%8D%B3%E5%85%B3%E7%B3%BB%E6%A8%A1%E5%BC%8F%29%E3%80%82%0A%E8%AF%AD%E5%8F%A5%E8%AF%B4%E6%98%8E%EF%BC%9A%0Aa.%E8%8B%A5%E7%9C%81%E7%95%A5%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E%E5%92%8C%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E%E5%88%99%E5%9C%A8%E5%BD%93%E5%89%8D%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%BB%BA%E7%AB%8B%E4%B8%80%E4%B8%AA%E8%A1%A8%EF%BC%8C%E5%90%A6%E5%88%99%E5%9C%A8%E6%8C%87%E5%AE%9A%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%BB%BA%E7%AB%8B%E4%B8%80%E4%B8%AA%E8%A1%A8%E3%80%82%3C%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%90%8D%3E%E4%BD%BF%E7%94%A8%E6%88%B7%E7%BB%99%E6%89%80%E5%AE%9A%E4%B9%89%E7%9A%84%E8%A1%A8%E6%89%80%E8%B5%B7%E7%9A%84%E5%90%8D%E5%AD%97%E3%80%82%3C%E5%88%97%E5%AE%9A%E4%B9%89%3E%E5%8F%AF%E4%BB%A5%E5%9C%A8%E4%B8%80%E4%B8%AA%E8%A1%A8%E5%AE%9A%E4%B9%89%E4%B8%AD%E5%87%BA%E7%8E%B0%E4%B8%80%E6%AC%A1%E6%88%96%E5%A4%9A%E6%AC%A1%EF%BC%8C%E6%AF%8F%E4%B8%AA%3C%E5%88%97%E5%AE%9A%E4%B9%89%3E%E5%8C%85%E6%8B%AC%E5%88%97%E5%90%8D%EF%BC%88%E5%8D%B3%E5%B1%9E%E6%80%A7%E5%90%8D%29%E3%80%81%E7%9B%B8%E5%BA%94%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B%E5%92%8C%E8%AF%A5%E5%88%97%E7%9A%84%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%E7%AD%89%E5%86%85%E5%AE%B9%E3%80%82%E5%9C%A8%E6%89%80%E6%9C%89%E5%88%97%E5%AE%9A%E4%B9%89%E4%B9%8B%E5%90%8E%E5%8F%AF%E4%BB%A5%E7%BB%99%E5%87%BA%E8%A1%A8%E7%BA%A7%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%E3%80%82b.%E5%8F%AF%E4%BD%BF%E7%94%A8%E7%9A%84%E6%95%B0%E6%8D%AE%E7%B1%BB%E5%9E%8B%E4%B8%BB%E8%A6%81%E6%9C%89%E4%BB%A5%E4%B8%8B%E5%9B%9B%E7%A7%8D%EF%BC%9Achar%28n%29%20%E5%AE%9A%E9%95%BF%E5%AD%97%E7%AC%A6%E5%9E%8Bint%20%E6%95%B4%E5%9E%8Bfloat%20%E6%B5%AE%E7%82%B9%E5%9E%8B%EF%BC%8C%E5%8F%88%E7%A7%B0%E5%AE%9E%E6%95%B0%E5%9E%8Bdate%20%E6%97%A5%E6%9C%9F%E5%9E%8B%0Ac.%E5%88%97%E7%BA%A7%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%E6%9C%89%E4%BB%A5%E4%B8%8B%E5%85%AD%E7%A7%8D%3A%0A1.DEFAULT%20%3C%E5%B8%B8%E9%87%8F%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%E9%BB%98%E8%AE%A4%E5%80%BC%E7%BA%A6%E6%9D%9F%E3%80%82%0A2.NULL/NOT%20NULL%20%E7%A9%BA%E5%80%BC/%E9%9D%9E%E7%A9%BA%E5%80%BC%E7%BA%A6%E6%9D%9F%E3%80%82%E6%B3%A8%E6%98%8E%E6%AF%8F%E8%A1%8C%E4%B8%8A%E7%9A%84%E8%AF%A5%E5%88%97%E5%80%BC%E4%B8%BA%E7%A9%BA%E3%80%82%0A3.PRIMARY%20KEY%20%E4%B8%BB%E7%A0%81%E7%BA%A6%E6%9D%9F%E3%80%82%E6%B3%A8%E6%98%8E%E8%AF%A5%E5%88%97%E4%B8%BA%E5%85%B3%E7%B3%BB%E7%9A%84%E4%B8%BB%E7%A0%81%E3%80%824.UNIQUE%E5%8D%95%E5%80%BC%E7%BA%A6%E6%9D%9F%EF%BC%8C%E5%8F%88%E7%A7%B0%E5%94%AF%E4%B8%80%E5%80%BC%E7%BA%A6%E6%9D%9F%E3%80%82%E5%BF%85%E9%A1%BB%E4%B8%8D%E7%9B%B8%E5%90%8Cd.%E8%A1%A8%E7%BA%A7%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%E5%8C%85%E6%8B%AC%E4%BB%A5%E4%B8%8B%E5%9B%9B%E7%A7%8D%EF%BC%9A1.%20PRIMARY%20KEY%20%28%3C%E5%88%97%E5%90%8D%3E%2C%E2%80%A6%EF%BC%89%E4%B8%BB%E7%A0%81%E7%BA%A6%E6%9D%9F%E3%80%82%E6%B3%A8%E6%98%8E%E4%B8%80%E5%88%97%E6%88%96%E5%90%8C%E6%97%B6%E5%A4%9A%E4%B8%AA%E5%88%97%E4%B8%BA%E5%85%B3%E7%B3%BB%E7%9A%84%E4%B8%BB%E7%A0%81%E3%80%82%0A2.%20UNIQUE%E5%8D%95%E5%80%BC%E7%BA%A6%E6%9D%9F%E3%80%82%E4%B8%80%E4%B8%AA%E6%88%96%E5%90%8C%E6%97%B6%E8%8B%A5%E5%B9%B2%E4%B8%AA%E5%88%97%E4%B8%BA%E5%8D%95%E5%80%BC%E3%80%82%0A3.FOREIGN%20KEY%20%28%3C%E5%88%97%E5%90%8D%2C%E2%80%A6%3E%29%20REFERENCES%20%3C%E7%88%B6%E8%A1%A8%E5%90%8D%3E%20%28%3C%E4%B8%BB%E7%A0%81%E5%88%97%E5%90%8D%3E%2C%E2%80%A6%29%20%E5%A4%96%E7%A0%81%E7%BA%A6%E6%9D%9F%E3%80%824.CHECK%20%28%3C%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%29%20%E6%A3%80%E6%9F%A5%E7%BA%A6%E6%9D%9F%E3%80%82%0A5.REFERENCES%20%3C%E7%88%B6%E8%A1%A8%E5%90%8D%3E%20%28%3C%E4%B8%BB%E7%A0%81%3E%29%E5%A4%96%E7%A0%81%E7%BA%A6%E6%9D%9F%E3%80%826.CHECK%20%28%3C%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%29%20%E6%A3%80%E6%9F%A5%E7%BA%A6%E6%9D%9F%E3%80%82%E6%B3%A8%E6%98%8E%E8%AF%A5%E5%88%97%E7%9A%84%E5%8F%96%E5%80%BC%E6%9D%A1%E4%BB%B6%EF%BC%8C%E6%88%96%E7%A7%B0%E5%8F%96%E5%80%BC%E9%99%90%E5%88%B6%E3%80%82%E6%B3%A8%EF%BC%9A%E8%8B%A5%E5%8F%AA%E6%B6%89%E5%8F%8A%E5%88%B0%E4%B8%80%E4%B8%AA%E5%88%97%E6%97%B6%EF%BC%8C%E5%88%99%E6%97%A2%E5%8F%AF%E4%BB%A5%E4%BD%9C%E4%B8%BA%E5%88%97%E7%BA%A7%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%EF%BC%8C%E5%8F%88%E5%8F%AF%E4%BB%A5%E4%BD%9C%E4%B8%BA%E8%A1%A8%E7%BA%A7%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%EF%BC%8C%E5%BD%93%E7%84%B6%E5%8F%AA%E5%8F%96%E5%85%B6%E4%B8%80%E3%80%82%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9A%0A%281%EF%BC%89%20create%20table%20%E5%AD%A6%E7%94%9F%20%28%E5%AD%A6%E7%94%9F%E5%8F%B7%20char%287%29%20primary%20key%2C%E5%A7%93%E5%90%8D%20char%286%29%20not%20null%20unique%2C%0A%E6%80%A7%E5%88%AB%20char%282%29%20not%20null%20chech%28%E6%80%A7%E5%88%AB%3D%E2%80%98%E7%94%B7%E2%80%99or%20%E6%80%A7%E5%88%AB%3D%E2%80%98%E5%A5%B3%E2%80%98%29%2C%E5%87%BA%E7%94%9F%E6%97%A5%E6%9C%9F%20datetime%20check%28%E5%87%BA%E7%94%9F%E6%97%A5%E6%9C%9F%3C%E2%80%981993-12-31%E2%80%99%29%2C%E4%B8%93%E4%B8%9A%20char%2810%29%2C%E5%B9%B4%E7%BA%A7%20int%20check%28%E5%B9%B4%E7%BA%A7%3E%3D1%20and%20%E5%B9%B4%E7%BA%A7%3C%3D4%29%29%20%0A%282%29%20Create%20table%20%E8%AF%BE%E7%A8%8B%28%E8%AF%BE%E7%A8%8B%E5%8F%B7%20char%284%29%20primary%20key%2C%E8%AF%BE%E7%A8%8B%E5%90%8D%20char%2810%29%20not%20null%20unique%2C%E8%AF%BE%E7%A8%8B%E5%AD%A6%E5%88%86%20int%20check%20%28%E8%AF%BE%E7%A8%8B%E5%AD%A6%E5%88%86%3E%3D1%20and%20%E8%AF%BE%E7%A8%8B%E5%AD%A6%E5%88%86%3C%3D6%29%29%20%283%29%20Create%20table%20%E9%80%89%E8%AF%BE%20%28%E5%AD%A6%E7%94%9F%E5%8F%B7%20char%287%29%2C%0A%E8%AF%BE%E7%A8%8B%E5%8F%B7%20char%284%29%2C%0A%E6%88%90%E7%BB%A9%20int%20check%20%28%E6%88%90%E7%BB%A9%3E%3D0%20and%20%E6%88%90%E7%BB%A9%3C%3D100%29%2Cprimary%20key%20%28%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E8%AF%BE%E7%A8%8B%E5%8F%B7%29%2C%0Aforeign%20key%20%28%E5%AD%A6%E7%94%9F%E5%8F%B7%29%20references%20%E5%AD%A6%E7%94%9F%20%28%E5%AD%A6%E7%94%9F%E5%8F%B7%29%2Cforeign%20key%20%28%E8%AF%BE%E7%A8%8B%E5%8F%B7%29%20references%20%E8%AF%BE%E7%A8%8B%20%28%E8%AF%BE%E7%A8%8B%E5%8F%B7%29%29%E4%B8%89%E3%80%81%E8%A1%A8%E5%86%85%E5%AE%B9%E7%9A%84%E6%8F%92%E5%85%A5%E3%80%81%E4%BF%AE%E6%94%B9%E5%92%8C%E5%88%A0%E9%99%A41%E3%80%81%E6%8F%92%E5%85%A5%E8%AE%B0%E5%BD%95%0A%E5%90%91%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%AD%E6%8F%92%E5%85%A5%E8%AE%B0%E5%BD%95%E6%9C%89%E4%B8%A4%E7%A7%8D%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%8C%E4%B8%80%E7%A7%8D%E6%98%AF%E5%8D%95%E8%A1%8C%E6%8F%92%E5%85%A5%EF%BC%8C%E5%8F%A6%E4%B8%80%E7%A7%8D%E6%98%AF%E5%A4%9A%E8%A1%8C%E6%8F%92%E5%85%A5%E3%80%82%E5%8D%95%E8%A1%8C%E6%8F%92%E5%85%A5%EF%BC%9A%0A%E6%A0%BC%E5%BC%8F%20%EF%BC%9AINSERT%20%5BINTO%5D%20%5B%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E.%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E.%5D%3C%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%90%8D%20%3E%28%3C%E5%88%97%E5%90%8D%3E%2C%E2%80%A6%29VALUES%20%3CSELECT%20%E5%AD%90%E5%8F%A5%3E%E5%A4%9A%E8%A1%8C%E6%8F%92%E5%85%A5%EF%BC%9A%0A%E6%A0%BC%E5%BC%8F%EF%BC%9AINSERT%20%28INTO%29%20%5B%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E.%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E.%5D%3C%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%90%8D%20%3E%28%3C%E5%88%97%E5%90%8D%3E%2C%E2%80%A6%29%20%3CSELECT%E5%AD%90%E5%8F%A5%3E%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%0A%E5%90%91%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%AD%E6%89%80%E6%8C%87%E5%AE%9A%E7%9A%84%E8%8B%A5%E5%B9%B2%E5%88%97%E6%8F%92%E5%85%A5%E4%B8%80%E8%A1%8C%E6%88%96%E5%A4%9A%E8%A1%8C%E6%95%B0%E6%8D%AE%E3%80%82%0A%E6%B3%A8%E6%84%8F%EF%BC%9A%E5%BD%93%E5%88%97%E5%80%BC%E4%B8%BA%E5%AD%97%E7%AC%A6%E4%B8%B2%E6%88%96%E6%97%A5%E6%9C%9F%E6%97%B6%EF%BC%8C%E5%BF%85%E9%A1%BB%E7%94%A8%E5%8D%95%E5%BC%95%E5%8F%B7%E6%8B%AC%E8%B5%B7%E6%9D%A5%EF%BC%8C%E4%BB%A5%E5%8C%BA%E5%88%AB%E4%BA%8E%E6%95%B0%E5%80%BC%E6%95%B0%E6%8D%AE%E3%80%82%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9Ap792%E3%80%81%E4%BF%AE%E6%94%B9%E8%A1%A8%E7%BB%93%E6%9E%84%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0AALTER%20TABLE%20%5B%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E.%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E.%5D%3C%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%90%8D%20%3E%7BADD%20%3C%E5%88%97%E5%AE%9A%E4%B9%89%E2%80%A6%7CADD%20%3C%E8%A1%A8%E7%BA%A7%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%3E%2C%E2%80%A6%7CDROP%20COLUMN%20%3C%E5%88%97%E5%90%8D%3E%2C%E2%80%A6%7CDROP%20%3C%E7%BA%A6%E6%9D%9F%E5%90%8D%3E%2C%E2%80%A6%7D%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%E5%90%91%E5%B7%B2%E5%AE%9A%E4%B9%89%E8%BF%87%E7%9A%84%E8%A1%A8%E4%B8%AD%E6%B7%BB%E5%8A%A0%E4%B8%80%E4%BA%9B%E5%88%97%E7%9A%84%E5%AE%9A%E4%B9%89%E6%88%96%E4%B8%80%E4%BA%9B%E8%A1%A8%E7%BA%A7%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%EF%BC%8C%E6%88%96%E8%80%85%E4%BB%8E%E5%B7%B2%E5%AE%9A%E4%B9%89%E8%BF%87%E7%9A%84%E8%A1%A8%E4%B8%AD%E5%88%A0%E9%99%A4%E4%B8%80%E4%BA%9B%E5%88%97%E6%88%96%E4%B8%80%E4%BA%9B%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%E3%80%82%0A%E4%B8%BE%E4%BE%8B%EF%BC%9A%20%EF%BC%881%EF%BC%89alter%20table%20%E5%AD%A6%E7%94%9F%20add%20%E7%B1%8D%E8%B4%AF%20char%286%29%EF%BC%882%EF%BC%89%20alter%20table%20%E5%AD%A6%E7%94%9F%20drop%20column%20%E7%B1%8D%E8%B4%AF3%E3%80%81%E5%88%A0%E9%99%A4%E8%A1%A8%E7%BB%93%E6%9E%84%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0ADROP%20TABLE%20%5B%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E.%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E.%5D%3C%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%90%8D%3E%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%E4%BB%8E%E5%BD%93%E5%89%8D%E6%88%96%E7%BB%99%E5%AE%9A%E7%9A%84%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E5%88%A0%E9%99%A4%E4%B8%80%E4%B8%AA%E8%A1%A8%E3%80%82%E4%B8%BE%E4%BE%8B%EF%BC%9Adrop%20table%20%E5%AD%A6%E7%94%9F12%E3%80%81%E4%BF%AE%E6%94%B9%E8%AE%B0%E5%BD%95%0A%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0AUPDATE%20%5B%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E.%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E.%5D%3C%E7%9B%AE%E7%9A%84%E8%A1%A8%E5%90%8D%20%3E%20SET%20%3C%E5%88%97%E5%90%8D%3E%3D%3C%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%2C%E2%80%A6%5BFROM%3C%E6%BA%90%E8%A1%A8%E5%90%8D%3E%2C%E2%80%A6%5D%5BWHERE%20%3C%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%5D%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%0A%E6%8C%89%E6%9D%A1%E4%BB%B6%E4%BF%AE%E6%94%B9%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%AD%E4%B8%80%E4%BA%9B%E5%88%97%E7%9A%84%E5%80%BC%E3%80%81%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9A%281%29%20update%20%E8%81%8C%E5%B7%A5%20set%20%E5%B9%B4%E9%BE%84%3D%E5%B9%B4%E9%BE%84%2B1%0A%282%29%20Update%20%E8%81%8C%E5%B7%A5%20set%20%E5%9F%BA%E6%9C%AC%E5%B7%A5%E8%B5%84%3D%E8%81%8C%E5%B7%A51.%E5%9F%BA%E6%9C%AC%E5%B7%A5%E8%B5%84%2B%E8%81%8C%E5%B7%A51.%E8%81%8C%E5%8A%A1%E6%B4%A5%E8%B4%B4%20from%20%E8%81%8C%E5%B7%A51where%20%E8%81%8C%E5%B7%A5.%E8%81%8C%E5%B7%A5%E5%8F%B7%3D%E8%81%8C%E5%B7%A51.%E8%81%8C%E5%B7%A5%E5%8F%B7%283%29%20Update%20%E8%81%8C%E5%B7%A5%20set%20%E5%9F%BA%E6%9C%AC%E5%B7%A5%E8%B5%84%3D%E5%9F%BA%E6%9C%AC%E5%B7%A5%E8%B5%84%2A1.2%20where%20%E8%81%8C%E5%B7%A5%E5%8F%B7%3D%E2%80%98010405%E2%80%993%E3%80%81%E5%88%A0%E9%99%A4%E8%AE%B0%E5%BD%95%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0ADELETE%20%5BFROM%5D%20%5B%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E.%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E.%5D%3C%E7%9B%AE%E7%9A%84%E8%A1%A8%E5%90%8D%20%3E%20%5BFROM%3C%E6%BA%90%E8%A1%A8%E5%90%8D%3E%2C%E2%80%A6%5D%5BWHERE%20%3C%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%20%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%E5%88%A0%E9%99%A4%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%AD%E6%BB%A1%E8%B6%B3%E6%9D%A1%E4%BB%B6%E7%9A%84%E6%89%80%E6%9C%89%E8%A1%8C%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9A%0A%281%29%20delete%20from%20%E8%81%8C%E5%B7%A5%20where%20%E5%B9%B4%E9%BE%84%3E45%0A%282%29%20Delete%20%E8%81%8C%E5%B7%A5%20from%20%E8%81%8C%E5%B7%A51%20where%20%E8%81%8C%E5%B7%A5.%E8%81%8C%E5%B7%A5%E5%8F%B7%3D%E8%81%8C%E5%B7%A51.%E8%81%8C%E5%B7%A5%E5%8F%B7%283%29%20Delete%20%E8%81%8C%E5%B7%A5%E5%9B%9B%E3%80%81%E8%A7%86%E5%9B%BE%E7%9A%84%E5%BB%BA%E7%AB%8B%E3%80%81%E4%BF%AE%E6%94%B9%E5%92%8C%E5%88%A0%E9%99%A4%0A%E8%A7%86%E5%9B%BE%E6%98%AF%E5%9C%A8%E5%9F%BA%E6%9C%AC%E8%A1%A8%E4%B9%8B%E4%B8%8A%E5%BB%BA%E7%AB%8B%E7%9A%84%E8%A1%A8%EF%BC%8C%E5%AE%83%E7%9A%84%E7%BB%93%E6%9E%84%28%E5%8D%B3%E6%89%80%E6%9C%89%E5%88%97%E5%AE%9A%E4%B9%89%29%E5%92%8C%E5%86%85%E5%AE%B9%28%E5%8D%B3%E6%89%80%E6%9C%89%E6%95%B0%E6%8D%AE%E8%A1%8C%29%E9%83%BD%E6%9D%A5%E8%87%AA%E5%9F%BA%E6%9C%AC%E8%A1%A8%EF%BC%8C%E5%AE%83%E4%BE%9D%E6%8D%AE%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%AD%98%E5%9C%A8%E8%80%8C%E5%AD%98%E5%9C%A8%E3%80%82%E6%AF%8F%E4%B8%AA%E8%A7%86%E5%9B%BE%E7%9A%84%E5%88%97%E5%8F%AF%E4%BB%A5%E6%9D%A5%E8%87%AA%E5%90%8C%E4%B8%80%E4%B8%AA%E5%9F%BA%E6%9C%AC%E8%A1%A8%EF%BC%8C%E4%B9%9F%E5%8F%AF%E4%BB%A5%E6%9D%A5%E8%87%AA%E5%A4%9A%E4%B8%AA%E4%B8%8D%E5%90%8C%E7%9A%84%E5%9F%BA%E6%9C%AC%E8%A1%A8%E3%80%82%E5%AE%83%E6%98%AF%E5%9F%BA%E6%9C%AC%E8%A1%A8%E7%9A%84%E6%8A%BD%E8%B1%A1%E5%92%8C%E5%9C%A8%E9%80%BB%E8%BE%91%E6%84%8F%E4%B9%89%E4%B8%8A%E5%BB%BA%E7%AB%8B%E7%9A%84%E6%96%B0%E5%85%B3%E7%B3%BB%E3%80%82%E5%AF%B9%E8%A7%86%E5%9B%BE%E5%8F%AA%E8%83%BD%E8%BF%9B%E8%A1%8C%E4%BF%AE%E6%94%B9%E5%92%8C%E6%9F%A5%E8%AF%A2%E6%93%8D%E4%BD%9C%E3%80%821%E3%80%81%E5%BB%BA%E7%AB%8B%E8%A7%86%E5%9B%BE%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0ACREATE%20VIEW%20%3C%E8%A7%86%E5%9B%BE%E5%90%8D%3E%28%3C%E5%88%97%E5%90%8D%3E%2C%E2%80%A6%29%20AS%20%3CSELECT%20%E5%AD%90%E5%8F%A5%3E%E5%8A%9F%E8%83%BD%EF%BC%9A%E5%9C%A8%E5%BD%93%E5%89%8D%E5%BA%93%E4%B8%AD%E6%A0%B9%E6%8D%AESELECT%E5%AD%90%E5%B1%80%E7%9A%84%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E5%BB%BA%E7%AB%8B%E4%B8%80%E4%B8%AA%E8%A7%86%E5%9B%BE%EF%BC%8C%E5%8C%85%E6%8B%AC%E8%A7%86%E5%9B%BE%E7%9A%84%E7%BB%93%E6%9E%84%E5%92%8C%E5%86%85%E5%AE%B9%E3%80%82%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9A%0Acreate%20view%20%E6%88%90%E7%BB%A9%E8%A7%86%E5%9B%BE%E8%A1%A8%28%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E5%A7%93%E5%90%8D%2C%E8%AF%BE%E7%A8%8B%E5%8F%B7%2C%E8%AF%BE%E7%A8%8B%E5%90%8D%2C%E6%88%90%E7%BB%A9%29as%20select%20%E9%80%89%E8%AF%BE.%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E5%A7%93%E5%90%8D%2C%E9%80%89%E8%AF%BE.%E8%AF%BE%E7%A8%8B%E5%8F%B7%2C%E8%AF%BE%E7%A8%8B%E5%90%8D%2C%E6%88%90%E7%BB%A9from%20%E5%AD%A6%E5%8F%B7%2C%E8%AF%BE%E7%A8%8B%2C%E9%80%89%E8%AF%BEwhere%20%E5%AD%A6%E7%94%9F.%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E5%AD%A6%E7%94%9F%E5%8F%B7%20and%20%E8%AF%BE%E7%A8%8B.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E8%AF%BE%E7%A8%8B%E5%8F%B7and%20%E4%B8%93%E4%B8%9A%3D%E2%80%98%E7%94%B5%E5%AD%90%E2%80%99%0A2%E3%80%81%E4%BF%AE%E6%94%B9%E8%A7%86%E5%9B%BE%E5%86%85%E5%AE%B9%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0AUPDATE%20%5B%3C%E6%95%B0%E6%8D%AE%E5%BA%93%E5%90%8D%3E.%3C%E6%89%80%E6%9C%89%E8%80%85%E5%90%8D%3E.%5D%3C%E8%A7%86%E5%9B%BE%E5%90%8D%20%3E%0ASET%20%3C%E5%88%97%E5%90%8D%3E%3D%3C%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%2C%E2%80%A6%20%5D%5BFROM%3C%E6%BA%90%E8%A1%A8%E5%90%8D%3E%2C%E2%80%A6%5D%5BWHERE%20%3C%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%5D%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%E6%8C%89%E7%85%A7%E4%B8%80%E5%AE%9A%E6%9D%A1%E4%BB%B6%E5%AF%B9%E5%BD%93%E5%89%8D%E6%88%96%E6%8C%87%E5%AE%9A%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E7%9A%84%E4%B8%80%E4%BA%9B%E5%88%97%E5%80%BC%E8%BF%9B%E8%A1%8C%E4%BF%AE%E6%94%B9%E3%80%82%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9A%0Aupdate%20%E6%88%90%E7%BB%A9%E8%A7%86%E5%9B%BE%E8%A1%A8%20set%20%E6%88%90%E7%BB%A9%3D80%0Awhere%20%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E2%80%980102005%E2%80%99%20and%20%E8%AF%BE%E7%A8%8B%E5%8F%B7%3D%E2%80%98E002%E2%80%993%E3%80%81%E4%BF%AE%E6%94%B9%E8%A7%86%E5%9B%BE%E5%AE%9A%E4%B9%89%EF%BC%9A%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0AALTER%20VIEW%20%3C%E8%A7%86%E5%9B%BE%E5%90%8D%3E%20%28%3C%E5%88%97%E5%90%8D%3E%2C%E2%80%A6%29%20AS%20%3CSELECT%20%E5%AD%90%E5%8F%A5%3E%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%E5%9C%A8%E5%BD%93%E5%89%8D%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E4%BF%AE%E6%94%B9%E5%B7%B2%E7%9F%A5%E8%A7%86%E5%9B%BE%E7%9A%84%E5%88%97%2C%E5%AE%83%E4%B8%8ESELECT%E5%AD%90%E5%8F%A5%E7%9A%84%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E7%9B%B8%E5%AF%B9%E5%BA%94%E3%80%82%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9A%0A%281%29%20Create%20view%20%E5%AD%A6%E7%94%9F%E8%A7%86%E5%9B%BE%20%28%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E5%A7%93%E5%90%8D%29%20as%20select%20%E5%AD%A6%E7%94%9F%E5%8F%B7%EF%BC%8C%E5%A7%93%E5%90%8D%20from%20%E5%AD%A6%E7%94%9F%282%29%20Alter%20view%20%E5%AD%A6%E7%94%9F%E8%A7%86%E5%9B%BE%20%28%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E4%B8%93%E4%B8%9A%29%20as%20select%20%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E4%B8%93%E4%B8%9A%20from%20%E5%AD%A6%E7%94%9F4%E3%80%81%E5%88%A0%E9%99%A4%E8%A7%86%E5%9B%BE%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0ADROP%20VIEW%20%3C%E8%A7%86%E5%9B%BE%E5%90%8D%3E%E8%AF%AD%E5%8F%A5%E5%8A%9F%E8%83%BD%EF%BC%9A%E5%88%A0%E9%99%A4%E5%BD%93%E5%89%8D%E6%95%B0%E6%8D%AE%E5%BA%93%E4%B8%AD%E4%B8%80%E4%B8%AA%E8%A7%86%E5%9B%BE%E3%80%82%E8%AF%AD%E5%8F%A5%E4%B8%BE%E4%BE%8B%EF%BC%9Adrop%20view%20%E6%88%90%E7%BB%A9%E8%A7%86%E5%9B%BE%E8%A1%A8%E4%BA%94%E3%80%81SQL%E6%9F%A5%E8%AF%A2%0A1%E3%80%81SELECT%E8%AF%AD%E5%8F%A5%E6%A0%BC%E5%BC%8F%EF%BC%9A%0ASELECT%20%5BALL%7CDISTINCT%5D%7B%3C%E8%A1%A8%E8%BE%BE%E5%BC%8F1%3E%20%5BAS%5D%20%3C%E5%88%97%E5%90%8D1%3E%5D%5B%2C%3C%E8%A1%A8%E8%BE%BE%E5%BC%8F2%E3%80%89%5BAS%5D%20%3C%E5%88%97%E5%90%8D2%3E%E2%80%A6%20%7C%2A%7C%20%3C%E8%A1%A8%E5%88%AB%E5%90%8D%3E.%2A%7C%5BINTO%20%3C%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%90%8D%3E%5DFROM%20%3C%E8%A1%A8%E5%90%8D1%3E%20%5B%5BAS%5D%20%3C%E8%A1%A8%E5%88%AB%E5%90%8D1%3E%5D%5B%2C%3C%E8%A1%A8%E5%90%8D2%3E%20%5B%5BAS%5D%20%3C%E8%A1%A8%E5%88%AB%E5%90%8D2%3E%5D%E2%80%A6%5D%5BWHERE%20%3C%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F1%3E%5D%5BGROUP%20BY%20%3C%E5%88%86%E7%BB%84%E5%88%97%E5%90%8D1%3E%5B%2C%3C%E5%88%86%E7%BB%84%E5%88%97%E5%90%8D2%3E%E2%80%A6%5D%5BHAVING%20%3C%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F2%3E%5D%5BORDER%20BY%20%3C%E6%8E%92%E5%BA%8F%E5%88%97%E5%90%8D1%3E%20%5BASC%7CDESC%5D%5B%2C%3C%E6%8E%92%E5%BA%8F%E5%88%97%E5%90%8D2%3E%5BASC%7C%7CDESC%5D%E2%80%A6%5D%5D%E5%8A%9F%E8%83%BD%EF%BC%9A%E6%A0%B9%E6%8D%AE%E4%B8%80%E4%B8%AA%E6%88%96%E5%A4%9A%E4%B8%AA%E8%A1%A8%E6%8C%89%E6%9D%A1%E4%BB%B6%E8%BF%9B%E8%A1%8C%E6%9F%A5%E8%AF%A2%EF%BC%8C%E4%BA%A7%E7%94%9F%E5%87%BA%E4%B8%80%E4%B8%AA%E6%96%B0%E8%A1%A8%EF%BC%88%E5%8D%B3%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%EF%BC%89%EF%BC%8C%E8%AF%A5%E6%96%B0%E8%A1%A8%E8%A2%AB%E6%98%BE%E7%A4%BA%E5%87%BA%E6%9D%A5%E6%88%96%E8%80%85%E8%A2%AB%E5%91%BD%E5%90%8D%E4%BF%9D%E5%AD%98%E8%B5%B7%E6%9D%A5%E3%80%82%E8%AF%AD%E5%8F%A5%E8%AF%B4%E6%98%8E%EF%BC%9A%0Aa.%20Select%E9%80%89%E9%A1%B9%E7%BB%99%E5%A4%84%E5%9C%A8%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%E6%AF%8F%E4%B8%80%E8%A1%8C%28%E5%8D%B3%E6%AF%8F%E4%B8%80%E6%9D%A1%E8%AE%B0%E5%BD%95%29%E6%89%80%E5%8C%85%E5%90%AB%E7%9A%84%E5%88%97%EF%BC%8C%E4%BB%A5%E5%8F%8A%E5%86%B3%E5%AE%9A%E6%98%AF%E5%90%A6%E5%85%81%E8%AE%B8%E5%9C%A8%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%E5%87%BA%E7%8E%B0%E9%87%8D%E5%A4%8D%E8%A1%8C%EF%BC%88%E5%8D%B3%E5%86%85%E5%AE%B9%E5%AE%8C%E5%85%A8%E7%9B%B8%E5%90%8C%E7%9A%84%E8%AE%B0%E5%BD%95%EF%BC%89%EF%BC%9Bb.%20into%20%E9%80%89%E9%A1%B9%E5%86%B3%E5%AE%9A%E6%98%AF%E5%90%A6%E6%8A%8A%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%BB%A5%E5%9F%BA%E6%9C%AC%E8%A1%A8%E7%9A%84%E5%BD%A2%E5%BC%8F%E4%BF%9D%E5%AD%98%E8%B5%B7%E6%9D%A5%EF%BC%8C%E8%8B%A5%E9%9C%80%E8%A6%81%E5%88%99%E5%BA%94%E5%B8%A6%E6%9C%89%E8%AF%A5%E9%80%89%E9%A1%B9%3B%0Ac.%20from%E9%80%89%E9%A1%B9%E6%8F%90%E4%BE%9B%E7%94%A8%E4%BA%8E%E6%9F%A5%E8%AF%A2%E7%9A%84%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%92%8C%E8%A7%86%E5%9B%BE%EF%BC%8C%E5%AE%83%E4%BB%AC%E5%9D%87%E5%8F%AF%E4%BB%A5%E5%B8%A6%E6%9C%89%E8%A1%A8%E5%88%AB%E5%90%8D%EF%BC%8C%E7%A7%B0%E8%BF%99%E4%BA%9B%E8%A1%A8%E4%B8%BA%E6%BA%90%E8%A1%A8%EF%BC%8C%E8%80%8C%E6%8A%8A%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E7%A7%B0%E4%B8%BA%E7%9B%AE%E7%9A%84%E8%A1%A8%3B%0Ad.%20where%20%E9%80%89%E9%A1%B9%E7%94%A8%E6%9D%A5%E6%8C%87%E5%AE%9A%E4%B8%8D%E5%90%8C%E6%BA%90%E8%A1%A8%E4%B9%8B%E9%97%B4%E8%AE%B0%E5%BD%95%E7%9A%84%E8%BF%9E%E6%8E%A5%E6%9D%A1%E4%BB%B6%E5%92%8C%E6%AF%8F%E4%B8%AA%E6%BA%90%E8%A1%A8%E4%B8%AD%E8%AE%B0%E5%BD%95%E7%9A%84%E7%AD%9B%E9%80%89%EF%BC%88%E9%80%89%E6%8B%A9%EF%BC%89%E6%9D%A1%E4%BB%B6%EF%BC%8C%E5%8F%AA%E6%9C%89%E6%BB%A1%E8%B6%B3%E6%89%80%E7%BB%99%E8%BF%9E%E6%8E%A5%E6%9D%A1%E4%BB%B6%E5%92%8C%E7%AD%9B%E9%80%89%E6%9D%A1%E4%BB%B6%E7%9A%84%E8%AE%B0%E5%BD%95%E6%89%8D%E8%83%BD%E8%A2%AB%E5%86%99%E5%85%A5%E5%88%B0%E7%9B%AE%E7%9A%84%E8%A1%A8%E4%B8%AD%EF%BC%9Be.%20group%20by%20%E9%80%89%E9%A1%B9%E7%94%A8%E4%BA%8E%E4%BD%BF%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E5%8F%AA%E5%8C%85%E5%90%AB%E6%8C%89%E6%8C%87%E5%AE%9A%E5%88%97%E7%9A%84%E5%80%BC%E8%BF%9B%E8%A1%8C%E5%88%86%E7%BB%84%E7%9A%84%E7%BB%9F%E8%AE%A1%E4%BF%A1%E6%81%AF%EF%BC%9Bf.%20having%20%E5%AD%90%E5%8F%A5%E9%80%9A%E5%B8%B8%E5%90%8Cgroup%20by%20%E9%80%89%E9%A1%B9%E4%B8%80%E8%B5%B7%E4%BD%BF%E7%94%A8%EF%BC%8C%E7%AD%9B%E9%80%89%E5%87%BA%E7%AC%A6%E5%90%88%E6%9D%A1%E4%BB%B6%E7%9A%84%E5%88%86%E7%BB%84%E7%BB%9F%E8%AE%A1%E4%BF%A1%E6%81%AF%EF%BC%9Bg.%20order%20by%20%E9%80%89%E9%A1%B9%E7%94%A8%E4%BA%8E%E5%B0%86%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E6%8C%89%E6%8C%87%E5%AE%9A%E5%88%97%E5%80%BC%E7%9A%84%E5%8D%87%E5%BA%8F%E6%88%96%E9%99%8D%E5%BA%8F%E6%8E%92%E5%BA%8F%E3%80%82%E5%9C%A8%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E4%B8%AD%EF%BC%8C%E9%80%9A%E8%BF%87select%20%E9%80%89%E9%A1%B9%E5%AE%9E%E7%8E%B0%E6%8A%95%E5%BD%B1%E8%BF%90%E7%AE%97%EF%BC%8C%E9%80%9A%E8%BF%87from%E9%80%89%E9%A1%B9%E5%92%8Cwhere%E9%80%89%E9%A1%B9%E6%98%AF%E5%AE%9E%E7%8E%B0%E8%BF%9E%E6%8E%A5%E5%92%8C%E9%80%89%E6%8B%A9%E8%BF%90%E7%AE%97%EF%BC%88%E5%9C%A8SQL%E6%96%B0%E7%89%88%E6%9C%AC%E4%B8%AD%EF%BC%8C%E7%94%A8from%20%E9%80%89%E9%A1%B9%E4%B8%93%E9%97%A8%E5%AE%9E%E7%8E%B0%E8%BF%9E%E6%8E%A5%E8%BF%90%E7%AE%97%EF%BC%8C%E7%94%A8where%20%E9%80%89%E9%A1%B9%E4%B8%93%E9%97%A8%E5%AE%9E%E7%8E%B0%E9%80%89%E6%8B%A9%E8%BF%90%E7%AE%97%EF%BC%892%E3%80%81SELECT%20%E9%80%89%E9%A1%B9%0A%E5%9C%A8%E8%AF%A5%E9%80%89%E9%A1%B9%E4%B8%AD%EF%BC%8CALL/DISTING%E4%B8%BA%E4%BB%BB%E9%80%89%E9%A1%B9%EF%BC%8C%E8%8B%A5%E9%80%89%E6%8B%A9ALL%2C%E5%88%99%E5%85%81%E8%AE%B8%E5%9C%A8%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%E5%87%BA%E7%8E%B0%E5%86%85%E5%AE%B9%E9%87%8D%E5%A4%8D%E7%9A%84%E8%A1%8C%EF%BC%88%E8%AE%B0%E5%BD%95%EF%BC%89%EF%BC%8C%E8%8B%A5%E9%80%89%E6%8B%A9DISTINCT%2C%E5%88%99%E5%9C%A8%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%E4%B8%8D%E5%85%81%E8%AE%B8%E5%87%BA%E7%8E%B0%E5%86%85%E5%AE%B9%E9%87%8D%E5%A4%8D%E7%9A%84%E8%A1%8C%EF%BC%8C%E5%8D%B3%E5%8F%AA%E6%9C%89%E5%86%85%E5%AE%B9%E4%BA%92%E4%B8%8D%E7%9B%B8%E5%90%8C%E7%9A%84%E8%AE%B0%E5%BD%95%E6%89%8D%E8%83%BD%E8%A2%AB%E5%86%99%E5%85%A5%E5%88%B0%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%EF%BC%8C%E8%8B%A5%E7%9C%81%E7%95%A5%E8%AF%A5%E9%80%89%E9%A1%B9%EF%BC%8C%E5%88%99%E9%9A%90%E5%90%AB%E4%B8%BAALL.%E5%BA%94%E7%94%A8%E4%B8%BE%E4%BE%8B%EF%BC%9AP89%20%E4%BE%8B4-1%E2%80%94%E2%80%944-103%E3%80%81FROM%E9%80%89%E9%A1%B9%20%E4%BE%8B4-11%0A4%E3%80%81WHERE%E9%80%89%E9%A1%B9%20%E4%BE%8B4-12%E2%80%94%E2%80%944-16Record%23%20%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%20%E5%88%86%E7%B1%BB%E5%90%8D%20%E5%8D%95%E4%BB%B7%20%E6%95%B0%E9%87%8F1%20DSJ-120%20%E7%94%B5%E8%A7%86%E6%9C%BA%201865.00%20152%20DSJ180%20%E7%94%B5%E8%A7%86%E6%9C%BA%202073.00%20103%20XYJ-13%20%E6%B4%97%E8%A1%A3%E6%9C%BA%20486.00%20204%20XYJ-20%20%E6%B4%97%E8%A1%A3%E6%9C%BA%20873.00%20125%20DBX-134%20%E7%94%B5%E5%86%B0%E7%AE%B1%201456.00%2086%20DSJ340%20%E7%94%B5%E8%A7%86%E6%9C%BA%203726.00%2057%20WBL-6%20%E5%BE%AE%E6%B3%A2%E7%82%89%20640.00%20108%20KTQ-12%20%E7%A9%BA%E8%B0%83%E5%99%A8%202800.00%2012SPK1%EF%BC%88%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%20C%EF%BC%888%EF%BC%89%EF%BC%8C%E5%88%86%E7%B1%BB%E5%90%8D%20C%EF%BC%886%EF%BC%89%EF%BC%8C%E5%8D%95%E4%BB%B7%20N%EF%BC%888%EF%BC%8C2%EF%BC%89%EF%BC%8C%E6%95%B0%E9%87%8F%20N%EF%BC%883%EF%BC%89%EF%BC%89%E4%B8%80%E3%80%81%E7%AE%80%E5%8D%95%E6%9F%A5%E8%AF%A2%0A%E4%BE%8B1%20%E4%BB%8ESPK1%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%AF%8F%E4%B8%AA%E8%AE%B0%E5%BD%95%E7%9A%84%E5%88%86%E7%B1%BB%E5%90%8D%E5%AD%97%E6%AE%B5%E7%9A%84%E5%80%BC%E3%80%82SELECT%20ALL%20%E5%88%86%E7%B1%BB%E5%90%8D%20FROM%20SPK1%E4%BE%8B2%20%E4%BB%8ESPK1%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E7%9A%84%E4%B8%8D%E5%90%8C%E5%88%86%E7%B1%BB%E5%90%8D%E3%80%82SELECT%20DISTINCT%20%E5%88%86%E7%B1%BB%E5%90%8D%20FROM%20SPK1%E7%BB%83%E4%B9%A0%EF%BC%9A1%E3%80%81%E4%BB%8ESPK1%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%8D%95%E4%BB%B7%E4%BD%8E%E4%BA%8E2000%E5%85%83%E7%9A%84%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%E3%80%81%E5%88%86%E7%B1%BB%E5%90%8D%E5%92%8C%E5%8D%95%E4%BB%B7%E3%80%822%E3%80%81%E4%BB%8ESPK1%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%8D%95%E4%BB%B7%E5%9C%A81000%E5%85%83%E8%87%B32500%E5%85%83%E4%B9%8B%E9%97%B4%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E3%80%82%0A%E4%BE%8B3%20%E4%BB%8ESPK1%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%88%86%E7%B1%BB%E5%90%8D%E4%B8%BA%E2%80%9C%E7%94%B5%E8%A7%86%E6%9C%BA%E2%80%9D%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81SELECT%20%2A%EF%BC%9BFROM%20SPK1%EF%BC%9B%0AWHERE%20%E5%88%86%E7%B1%BB%E5%90%8D%3D%E2%80%9C%E7%94%B5%E8%A7%86%E6%9C%BA%E2%80%9D%E7%94%A8AS%E6%8C%87%E5%87%BA%E5%AD%97%E6%AE%B5%E5%88%AB%E5%90%8D%EF%BC%9A%0A%E4%BE%8B4%20%E4%BB%8ESPK1%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%AF%8F%E4%B8%80%E7%A7%8D%E5%95%86%E5%93%81%E7%9A%84%E6%9C%80%E9%AB%98%E4%BB%B7%E5%80%BC%E3%80%81%E6%9C%80%E4%BD%8E%E4%BB%B7%E5%80%BC%E3%80%82SELECT%20MAX%EF%BC%88%E5%8D%95%E4%BB%B7%2A%E6%95%B0%E9%87%8F%EF%BC%89AS%20%E6%9C%80%E9%AB%98%E4%BB%B7%E5%80%BC%EF%BC%8CMIN%EF%BC%88%E5%8D%95%E4%BB%B7%2A%E6%95%B0%E9%87%8F%EF%BC%89AS%20%E6%9C%80%E4%BD%8E%E4%BB%B7%E5%80%BC%EF%BC%9BFROM%20SPK1%0A%E5%9C%A8SQL-SELECT%E5%91%BD%E4%BB%A4%E4%B8%AD%EF%BC%8C%E4%BD%BF%E7%94%A8%E7%9A%84%E5%AD%97%E6%AE%B5%E5%87%BD%E6%95%B0%E6%9C%89%EF%BC%9ACOUNT%EF%BC%88%E3%80%88%E5%AD%97%E6%AE%B5%E5%90%8D%E3%80%89%7C%2A%EF%BC%89%20%E7%BB%9F%E8%AE%A1%E5%87%BA%E5%AF%B9%E5%BA%94%E5%AD%97%E6%AE%B5%E7%9A%84%E4%B8%AA%E6%95%B0%EF%BC%8C%E5%AE%83%E4%B9%9F%E5%B0%B1%E6%98%AF%E7%9B%B8%E5%BA%94%E7%9A%84%E8%AE%B0%E5%BD%95%E6%95%B0%EF%BC%8C%E9%80%9A%E5%B8%B8%E4%BD%BF%E7%94%A8%2A%E8%A1%A8%E7%A4%BA%E4%BB%BB%E4%B8%80%E5%AD%97%E6%AE%B5%E3%80%82MAX%EF%BC%88%E3%80%88%E5%AD%97%E6%AE%B5%E5%90%8D%E3%80%89%EF%BC%89%20%E6%B1%82%E5%87%BA%E6%9C%80%E5%A4%A7%E5%80%BC%E3%80%82MIN%EF%BC%88%E3%80%88%E5%AD%97%E6%AE%B5%E5%90%8D%E3%80%89%EF%BC%89%20%E6%B1%82%E5%87%BA%E6%9C%80%E5%B0%8F%E5%80%BC%E3%80%82%0AAVG%EF%BC%88%E3%80%88%E5%AD%97%E6%AE%B5%E5%90%8D%E3%80%89%EF%BC%89%20%E6%B1%82%E5%87%BA%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E5%80%BC%E5%AD%97%E6%AE%B5%E7%9A%84%E5%B9%B3%E5%9D%87%E5%80%BC%E3%80%82SMU%EF%BC%88%E3%80%88%E5%AD%97%E6%AE%B5%E5%90%8D%E3%80%89%EF%BC%89%20%E6%B1%82%E5%87%BA%E5%AF%B9%E5%BA%94%E7%9A%84%E6%95%B0%E5%80%BC%E5%AD%97%E6%AE%B5%E7%9A%84%E6%80%BB%E5%92%8C%E3%80%82Record%23%20%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%20%E4%BA%A7%E5%9C%B0%20%E5%93%81%E7%89%8C12345678%0ADSJ-120DSJ-180XYJ-13XYJ-20DBX-134DSJ-340WBL-6KTQ-12%E5%8D%97%E4%BA%AC%E5%8D%97%E4%BA%AC%E6%97%A0%E9%94%A1%E5%B1%B1%E8%A5%BF%E5%8C%97%E4%BA%AC%E5%8C%97%E4%BA%AC%E9%9D%92%E5%B2%9B%E6%97%A0%E9%94%A1%E7%86%8A%E7%8C%AB%E7%86%8A%E7%8C%AB%0A%E5%B0%8F%E5%A4%A9%E9%B9%85%E6%B5%B7%E6%A3%A0%0A%E9%9B%AA%E8%8A%B1%E7%89%A1%E4%B8%B9%E6%B5%B7%E4%BF%A1%E6%98%A5%E5%85%B0%0ASPK2%EF%BC%88%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7C%EF%BC%888%EF%BC%89%EF%BC%8C%E4%BA%A7%E5%9C%B0C%EF%BC%888%EF%BC%89%EF%BC%8C%E5%93%81%E7%89%8CC%EF%BC%888%EF%BC%89%E7%BB%83%E4%B9%A0%203%E3%80%81%E4%BB%8ESPK1%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%AF%8F%E4%B8%80%E7%A7%8D%E5%95%86%E5%93%81%E7%9A%84%E4%BB%B7%E5%80%BC%E3%80%824%E3%80%81%E6%9F%A5%E8%AF%A2%E5%87%BASPK1%E5%BA%93%E4%B8%AD%E5%88%86%E7%B1%BB%E5%90%8D%E4%B8%BA%E2%80%9C%E7%94%B5%E8%A7%86%E6%9C%BA%E2%80%9D%E7%9A%84%E5%95%86%E5%93%81%E7%A7%8D%E6%95%B0%E3%80%81%E6%9C%80%E9%AB%98%E4%BB%B7%E3%80%81%E6%9C%80%E4%BD%8E%E4%BB%B7%E5%8F%8A%E5%B9%B3%E5%9D%87%E4%BB%B7%E3%80%82%E7%BB%83%E4%B9%A0%E9%A2%98%E7%AD%94%E6%A1%88%EF%BC%9A%0A1%E3%80%81SELECT%20%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%EF%BC%8C%E5%88%86%E7%B1%BB%E5%90%8D%EF%BC%8C%E5%8D%95%E4%BB%B7%EF%BC%9BFROM%20SPK1%EF%BC%9BWHERE%20%E5%8D%95%E4%BB%B7%3C2000%0A2%E3%80%81%20SELECT%20%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%EF%BC%8C%E5%88%86%E7%B1%BB%E5%90%8D%EF%BC%8C%E5%8D%95%E4%BB%B7%EF%BC%9BFROM%20SPK1%EF%BC%9B%0AWHERE%20%E5%8D%95%E4%BB%B7%3E1000%20AND%20%E5%8D%95%E4%BB%B7%3C25003%E3%80%81SELECT%20%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%EF%BC%8C%E5%8D%95%E4%BB%B7%2A%E6%95%B0%E9%87%8F%20AS%20%E4%BB%B7%E5%80%BC%EF%BC%9BFROM%20SPK14%E3%80%81SELECT%20%E5%88%86%E7%B1%BB%E5%90%8D%EF%BC%8CCOUNT%EF%BC%88%2A%EF%BC%89%20AS%20%E7%A7%8D%E6%95%B0%EF%BC%9BMAX%EF%BC%88%E5%8D%95%E4%BB%B7%EF%BC%89AS%20%E6%9C%80%E9%AB%98%E4%BB%B7%EF%BC%8CMIN%EF%BC%88%E5%8D%95%E4%BB%B7%EF%BC%89AS%20%E6%9C%80%E4%BD%8E%E4%BB%B7%EF%BC%9BAVG%EF%BC%88%E5%8D%95%E4%BB%B7%EF%BC%89AS%20%E5%B9%B3%E5%9D%87%E4%BB%B7%EF%BC%9BFROM%20SPK1%EF%BC%9B%0AWHERE%20%E5%88%86%E7%B1%BB%E5%90%8D%3D%E2%80%9C%E7%94%B5%E8%A7%86%E6%9C%BA%E2%80%9DSELECT%20%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%EF%BC%8C%E5%93%81%E7%89%8C%EF%BC%9BFROM%20SPK2%EF%BC%9BWHERE%20%E4%BA%A7%E5%9C%B0%20IN%20%EF%BC%88%E5%8D%97%E4%BA%AC%EF%BC%8C%E5%8C%97%E4%BA%AC%EF%BC%89%0A%E4%BE%8B%20%E6%9F%A5%E6%89%BESPK1%E4%B8%AD%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E4%B8%AD%E6%95%B0%E9%87%8F%E5%A4%A7%E4%BA%8E10%E7%9A%84%E5%88%86%E7%B1%BB%E5%8F%B7%E5%8F%8A%E5%8D%95%E4%BB%B7%EF%BC%8C%E5%B9%B6%E6%8A%8A%E5%8D%95%E4%BB%B7%E6%8C%89%E9%99%8D%E7%BB%AD%E6%8E%92%E5%BA%8F%E3%80%82%E7%94%A8ORDER%20BY%20%E5%AF%B9%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E6%8E%92%E5%BA%8F%E5%9C%A8WHERE%E4%B8%AD%E4%BD%BF%E7%94%A8%E8%B0%93%E8%AF%8D%20IN%0A%E4%BE%8B%20%E6%9F%A5%E6%89%BESPK2%E4%B8%AD%E4%BA%A7%E5%9C%B0%E6%98%AF%E5%8D%97%E4%BA%AC%E6%88%96%E5%8C%97%E4%BA%AC%E7%9A%84%E5%95%86%E5%93%81%E7%9A%84%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%E3%80%81%E5%93%81%E7%89%8C%E3%80%82SELECT%20%E5%88%86%E7%B1%BB%E5%8F%B7%EF%BC%8C%E5%8D%95%E4%BB%B7%EF%BC%9BFROM%20SPK1%EF%BC%9BWHERE%20%E6%95%B0%E9%87%8F%3E%3D10%EF%BC%9BORDER%20BY%20%E5%8D%95%E4%BB%B7%20DESC%0A%E5%9C%A8WHERE%E4%B8%ADBETWEEN%E2%80%A6AND%E2%80%A6%E5%92%8CNOT%20BETWEEND%20%E4%BD%BF%E7%94%A8%E4%BE%8B%20%E4%BB%8ESPK1%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%8D%95%E4%BB%B7%E5%9C%A81000%E5%85%83%E8%87%B32500%E5%85%83%E4%B9%8B%E9%97%B4%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E3%80%82SELECT%20%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%EF%BC%8C%E5%88%86%E7%B1%BB%E5%90%8D%EF%BC%8C%E5%8D%95%E4%BB%B7%EF%BC%9BFROM%20SPK1%EF%BC%9B%0AWHERE%20%E5%8D%95%E4%BB%B7%20BETWEEN%201000%202500%E4%BE%8B4-11%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%AF%8F%E4%B8%AA%E5%AD%A6%E7%94%9F%E9%80%89%E4%BF%AE%E6%AF%8F%E9%97%A8%E8%AF%BE%E7%A8%8B%E7%9A%84%E5%AD%A6%E7%94%9F%E5%8F%B7%E3%80%81%E5%A7%93%E5%90%8D%E3%80%81%E8%AF%BE%E7%A8%8B%E5%8F%B7%E3%80%81%E8%AF%BE%E7%A8%8B%E5%90%8D%E3%80%81%E6%88%90%E7%BB%A9%E7%AD%89%E6%95%B0%E6%8D%AESelect%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E5%A7%93%E5%90%8D%2Cy.%E8%AF%BE%E7%A8%8B%E5%8F%B7%2C%E8%AF%BE%E7%A8%8B%E5%90%8D%2C%E6%88%90%E7%BB%A9From%20%E5%AD%A6%E7%94%9F%20x%2C%E8%AF%BE%E7%A8%8B%20y%2C%E9%80%89%E8%AF%BE%20z%0AWhere%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dz.%E5%AD%A6%E7%94%9F%E5%8F%B7%20and%20y.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3Dz.%E8%AF%BE%E7%A8%8B%E5%8F%B7%E4%BE%8B4-12%20%E4%BB%8E%E5%95%86%E5%93%81%E8%A1%A81%E7%A7%8D%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%8D%95%E4%BB%B7%E5%A4%A7%E4%BA%8E1500%EF%BC%8C%E5%90%8C%E6%97%B6%E6%95%B0%E9%87%8F%E5%A4%A7%E4%BA%8E%E7%AD%89%E4%BA%8E10%E7%9A%84%E5%95%86%E5%93%81%E3%80%82Select%20%2AFrom%20%E5%95%86%E5%93%81%E8%A1%A81%0AWhere%20%E5%8D%95%E4%BB%B7%3E%3D1500%20and%20%E6%95%B0%E9%87%8F%3E%3D10%E4%BE%8B13%20%E4%BB%8E%E5%95%86%E5%93%81%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E4%BA%A7%E5%9C%B0%E4%B8%BA%E5%8D%97%E4%BA%AC%E6%88%96%E6%97%A0%E9%94%A1%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E7%9A%84%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%E3%80%81%E5%88%86%E7%B1%BB%E5%90%8D%E3%80%81%E4%BA%A7%E5%9C%B0%E5%92%8C%E5%93%81%E7%89%8C%E3%80%82Select%20x.%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%2C%E5%88%86%E7%B1%BB%E5%90%8D%2C%E4%BA%A7%E5%9C%B0%2C%E5%93%81%E7%89%8CFrom%20%E5%95%86%E5%93%81%E8%A1%A81%20x%2C%E5%95%86%E5%93%81%E8%A1%A82%20yWhere%20x.%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%3Dy.%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%20and%28%E4%BA%A7%E5%9C%B0%3D%E2%80%98%E5%8D%97%E4%BA%AC%E2%80%99or%20%E4%BA%A7%E5%9C%B0%3D%E2%80%98%E6%97%A0%E9%94%A1%E2%80%99%29%E4%BE%8B%2014%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E9%80%89%E4%BF%AE%E8%87%B3%E5%B0%91%E4%B8%A4%E9%97%A8%E8%AF%BE%E7%A8%8B%E7%9A%84%E5%AD%A6%E7%94%9F%E5%AD%A6%E5%8F%B7%E3%80%82Select%20distinct%20x.%E5%AD%A6%E5%8F%B7From%20%E9%80%89%E8%AF%BE%20x%2C%E9%80%89%E8%AF%BE%20yWhere%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dy.%E5%AD%A6%E7%94%9F%E5%8F%B7%20and%20x.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3C%3Ey.%E8%AF%BE%E7%A8%8B%E5%8F%B7%E4%BE%8B%2015%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E9%80%89%E4%BF%AE%E4%BA%86%E8%AF%BE%E7%A8%8B%E5%90%8D%E4%B8%BA%E2%80%9C%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E2%80%9D%E8%AF%BE%E7%A8%8B%E6%AF%8F%E4%B8%AA%E5%AD%A6%E7%94%9F%E7%9A%84%E5%A7%93%E5%90%8D%E3%80%82Select%20%E5%A7%93%E5%90%8D%2C%E8%AF%BE%E7%A8%8B%0AFrom%20%E5%AD%A6%E7%94%9F%20x%2C%E8%AF%BE%E7%A8%8B%20y%2C%E9%80%89%E8%AF%BE%20z%0AWhere%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dz.%E5%AD%A6%E7%94%9F%E5%8F%B7%20and%20y.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3Dz.%E8%AF%BE%E7%A8%8B%E5%8F%B7and%20%E8%AF%BE%E7%A8%8B%E5%90%8D%3D%E2%80%98%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E2%80%99%0A%E6%B3%A8%E6%84%8F%EF%BC%9A%E5%9C%A8%E6%96%B0%E7%89%88%E7%9A%84SQL%E4%B8%AD%EF%BC%8C%E4%B8%BA%E4%BA%86%E4%BD%BF%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E6%9B%B4%E5%8A%A0%E7%BB%93%E6%9E%84%E5%8C%96%EF%BC%8C%E5%B7%B2%E7%BB%8F%E6%8A%8A%E6%9F%A5%E8%AF%A2%E8%BF%9E%E6%8E%A5%E6%9D%A1%E4%BB%B6%E4%BB%8EWHERE%E9%80%89%E9%A1%B9%E4%B8%AD%E8%BD%AC%E7%A7%BB%E5%88%B0FROM%E9%80%89%E9%A1%B9%E4%B8%AD%EF%BC%8C%E5%B9%B6%E4%B8%94%E8%BF%98%E4%B8%B0%E5%AF%8C%E4%BA%86%E8%BF%9E%E6%8E%A5%E7%9A%84%E5%8A%9F%E8%83%BD%EF%BC%8C%E9%99%A4%E4%BA%86%E4%B8%8A%E8%BF%B0%E4%BB%8B%E7%BB%8D%E7%9A%84%E4%B8%80%E8%88%AC%E8%BF%9E%E6%8E%A5%EF%BC%88%E5%9C%A8%E6%96%B0%E7%89%88%E6%9C%AC%E4%B8%AD%E7%A7%B0%E4%BD%9C%E4%B8%AD%E9%97%B4%E8%BF%9E%E6%8E%A5%EF%BC%89%E5%A4%96%EF%BC%8C%E8%BF%98%E5%A2%9E%E5%8A%A0%E4%BA%86%E5%B7%A6%E8%BF%9E%E6%8E%A5%E5%92%8C%E5%8F%B3%E8%BF%9E%E6%8E%A5%E7%9A%84%E5%8A%9F%E8%83%BD%E3%80%82%E5%9C%A8FROM%E9%80%89%E7%9B%B8%E4%B8%AD%E7%9A%84%E7%9B%B8%E5%BA%94%E8%AF%AD%E6%B3%95%E6%A0%BC%E5%BC%8F%E5%88%86%E5%88%AB%E4%B8%BA%EF%BC%9A%0A%E4%B8%AD%E9%97%B4%E8%BF%9E%E6%8E%A5%20FROM%20%3C%E8%A1%A8%E5%90%8D1%3E%20INNER%20JOIN%20%3C%E8%A1%A8%E5%90%8D2%3E%20ON%3C%E8%A1%A8%E5%90%8D1%3E.%3C%E8%BF%9E%E6%8E%A5%E5%88%97%E5%90%8D1%3E%20%3C%E6%AF%94%E8%BE%83%E7%AC%A6%3E%20%3C%E8%A1%A8%E5%90%8D2%3E.%3C%E8%BF%9E%E6%8E%A5%E5%88%97%E5%90%8D2%3E%E5%B7%A6%E8%BF%9E%E6%8E%A5%20FROM%20%3C%E8%A1%A8%E5%90%8D1%3E%20LEFT%20JOIN%20%3C%E8%A1%A8%E5%90%8D2%3E%20ON%3C%E8%A1%A8%E5%90%8D1%3E.%3C%E8%BF%9E%E6%8E%A5%E5%88%97%E5%90%8D1%3E%20%3C%E6%AF%94%E8%BE%83%E7%AC%A6%3E%20%3C%E8%A1%A8%E5%90%8D2%3E.%3C%E8%BF%9E%E6%8E%A5%E5%88%97%E5%90%8D2%3E%E5%8F%B3%E8%BF%9E%E6%8E%A5%20FROM%20%3C%E8%A1%A8%E5%90%8D1%3E%20RIGHT%20JOIN%20%3C%E8%A1%A8%E5%90%8D2%3E%20ON%3C%E8%A1%A8%E5%90%8D1%3E.%3C%E8%BF%9E%E6%8E%A5%E5%88%97%E5%90%8D1%3E%20%3C%E6%AF%94%E8%BE%83%E7%AC%A6%3E%20%3C%E8%A1%A8%E5%90%8D2%3E.%3C%E8%BF%9E%E6%8E%A5%E5%88%97%E5%90%8D2%3E%E6%AF%8F%E4%B8%80%E7%A7%8D%E8%BF%9E%E6%8E%A5%E9%83%BD%E9%9A%90%E5%90%AB%E7%9D%80%E5%8F%8C%E9%87%8D%E5%BE%AA%E7%8E%AF%E7%9A%84%E6%89%A7%E8%A1%8C%E8%BF%87%E7%A8%8B%EF%BC%9A%E5%AF%B9%E4%BA%8E%E4%B8%AD%E9%97%B4%E8%BF%9E%E6%8E%A5%EF%BC%8C%E5%A4%96%E5%BE%AA%E7%8E%AF%E4%BE%9D%E6%AC%A1%E6%89%AB%E6%8F%8F%E7%AC%AC%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%AF%8F%E4%B8%AA%E5%85%83%E7%BB%84%EF%BC%8C%E5%86%85%E5%BE%AA%E7%8E%AF%E4%BE%9D%E6%AC%A1%E6%89%AB%E6%8F%8F%E7%AC%AC%E4%BA%8C%E4%B8%AA%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%AF%8F%E4%B8%AA%E5%85%83%E7%BB%84%EF%BC%8C%E5%BD%93%E6%BB%A1%E8%B6%B3%E8%BF%9E%E6%8E%A5%E6%9D%A1%E4%BB%B6%E6%97%B6%E5%B0%B1%E8%BF%9E%E6%8E%A5%E8%B5%B7%E6%9D%A5%E5%BD%A2%E6%88%90%E4%B8%AD%E9%97%B4%E8%A1%A8%E4%B8%AD%E7%9A%84%E4%B8%80%E4%B8%AA%E6%96%B0%E5%85%83%E7%BB%84%EF%BC%9B%E5%AF%B9%E4%BA%8E%E5%B7%A6%E8%BF%9E%E6%8E%A5%EF%BC%8C%E9%99%A4%E4%BA%86%E6%8C%89%E4%B8%AD%E9%97%B4%E8%BF%9E%E6%8E%A5%E5%BD%A2%E6%88%90%E4%B8%AD%E9%97%B4%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%96%B0%E5%85%83%E7%BB%84%E5%A4%96%EF%BC%8C%E8%BF%98%E6%8A%8A%E7%AC%AC%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%B2%A1%E6%9C%89%E5%BD%A2%E6%88%90%E8%BF%9E%E6%8E%A5%E7%9A%84%E6%89%80%E6%9C%89%E5%85%83%E7%BB%84%E4%B9%9F%E5%8A%A0%E5%85%A5%E5%88%B0%E4%B8%AD%E9%97%B4%E8%A1%A8%E4%B8%AD%EF%BC%8C%E8%BF%99%E4%BA%9B%E5%85%83%E7%BB%84%E5%9C%A8%E7%AC%AC%E4%BA%8C%E4%B8%AA%E8%A1%A8%E4%B8%8A%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E5%88%97%E5%80%BC%E8%A2%AB%E8%87%AA%E5%8A%A8%E7%BD%AE%E4%B8%BA%E7%A9%BA%EF%BC%9B%0A%E5%AF%B9%E4%BA%8E%E5%8F%B3%E8%BF%9E%E6%8E%A5%EF%BC%8C%E9%99%A4%E4%BA%86%E6%8C%89%E4%B8%AD%E9%97%B4%E8%BF%9E%E6%8E%A5%E5%BD%A2%E6%88%90%E4%B8%AD%E9%97%B4%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%96%B0%E5%85%83%E7%BB%84%E5%A4%96%EF%BC%8C%E8%BF%98%E6%8A%8A%E7%AC%AC%E4%BA%8C%E4%B8%AA%E8%A1%A8%E4%B8%AD%E7%9A%84%E6%B2%A1%E6%9C%89%E5%BD%A2%E6%88%90%E8%BF%9E%E6%8E%A5%E7%9A%84%E6%89%80%E6%9C%89%E5%85%83%E7%BB%84%E4%B9%9F%E5%8A%A0%E5%85%A5%E5%88%B0%E4%B8%AD%E9%97%B4%E8%A1%A8%E4%B8%AD%EF%BC%8C%E8%BF%99%E4%BA%9B%E5%85%83%E7%BB%84%E5%9C%A8%E7%AC%AC%E4%B8%80%E4%B8%AA%E8%A1%A8%E4%B8%8A%E6%89%80%E5%AF%B9%E5%BA%94%E7%9A%84%E5%88%97%E5%80%BC%E8%A2%AB%E8%87%AA%E5%8A%A8%E7%BD%AE%E4%B8%BA%E7%A9%BA%E3%80%82%0A%E5%AE%8C%E6%88%90%E8%BF%9E%E6%8E%A5%E5%90%8E%EF%BC%8C%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E5%86%8D%E6%A0%B9%E6%8D%AEWHERE%E9%80%89%E9%A1%B9%E4%B8%AD%E6%8F%90%E4%BE%9B%E7%9A%84%E7%AD%9B%E9%80%89%E6%9D%A1%E4%BB%B6%E4%BB%8E%E4%B8%AD%E9%97%B4%E8%A1%A8%E4%B8%AD%E9%80%89%E6%8B%A9%E5%87%BA%E5%85%83%E7%BB%84%EF%BC%8C%E7%84%B6%E5%90%8E%E5%86%8D%E6%A0%B9%E6%8D%AESELECT%E9%80%89%E9%A1%B9%E6%8A%95%E5%BD%B1%E5%87%BA%E6%89%80%E9%9C%80%E8%A6%81%E7%9A%84%E5%88%97%E5%BD%A2%E6%88%90%E7%BB%93%E6%9E%9C%E8%A1%A8%E3%80%82%E4%BE%8B%2016.a%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9F%E7%9A%84%E9%80%89%E8%AF%BE%E6%83%85%E5%86%B5%EF%BC%8C%E8%A6%81%E6%B1%82%E6%B2%A1%E9%80%89%E4%BF%AE%E4%BB%BB%E4%BD%95%E8%AF%BE%E7%A8%8B%E7%9A%84%E5%AD%A6%E7%94%9F%E4%BF%A1%E6%81%AF%E4%B9%9F%E8%A6%81%E5%8F%8D%E6%98%A0%E5%87%BA%E6%9D%A5Select%20%2A%0AFrom%20%E5%AD%A6%E7%94%9F%20left%20join%20%E9%80%89%E8%AF%BE%20on%20%E5%AD%A6%E7%94%9F.%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E5%AD%A6%E7%94%9F%E5%8F%B7%E4%BE%8B%2016.b%20%E4%BB%8E%E5%AD%A6%E7%94%9F%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%89%80%E6%9C%89%E8%AF%BE%E7%A8%8B%E8%A2%AB%E5%AD%A6%E7%94%9F%E9%80%89%E4%BF%AE%E7%9A%84%E6%83%85%E5%86%B5Select%20%2A%0AFrom%20%E8%AF%BE%E7%A8%8B%20left%20join%20%28%E9%80%89%E8%AF%BE%20inner%20join%20%E5%AD%A6%E7%94%9F%20on%E9%80%89%E4%BF%AE.%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E5%AD%A6%E7%94%9F%E5%8F%B7%29%20on%20%E8%AF%BE%E7%A8%8B.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E8%AF%BE%E7%A8%8B%E5%8F%B7%E4%BE%8B%2016.c%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%89%80%E6%9C%89%E7%94%B5%E5%AD%90%E4%B8%93%E4%B8%9A%E7%9A%84%E5%AD%A6%E7%94%9F%E9%80%89%E8%AF%BE%E7%9A%84%E5%85%A8%E9%83%A8%E6%83%85%E5%86%B5Select%20%2AFrom%20%E5%AD%A6%E7%94%9F%20inner%20join%20%28%E9%80%89%E8%AF%BE%20inner%20join%20%E8%AF%BE%E7%A8%8B%20on%20%E9%80%89%E8%AF%BE.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3D%E8%AF%BE%E7%A8%8B.%E8%AF%BE%E7%A8%8B%E5%8F%B7%29on%20%E5%AD%A6%E7%94%9F.%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E5%AD%A6%E7%94%9F%E5%8F%B7%0AWhere%20%E4%B8%93%E4%B8%9A%3D%E2%80%98%E7%94%B5%E5%AD%90%E2%80%99%20%28%E4%B8%8E%E4%BC%A0%E7%BB%9F%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E7%AD%89%E6%95%88%29%0A%E7%94%A8%E4%BA%8E%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E4%B8%AD%E7%9A%84%E4%B8%93%E9%97%A8%E6%AF%94%E8%BE%83%E5%BC%8F%E5%8F%88%E5%8F%AB%E5%88%A4%E6%96%AD%E5%BC%8F%EF%BC%8C%E5%AE%83%E5%AE%9E%E7%8E%B0%E5%8D%95%E5%80%BC%E4%B8%8E%E9%9B%86%E5%90%88%E6%95%B0%E6%8D%AE%E4%B9%8B%E9%97%B4%E7%9A%84%E6%AF%94%E8%BE%83%E3%80%82%E5%B8%B8%E7%94%A8%E7%9A%84%E6%9C%89%E4%BB%A5%E4%B8%8B%E5%85%AD%E7%A7%8D%E6%A0%BC%E5%BC%8F%E3%80%82%E6%A0%BC%E5%BC%8F1%EF%BC%9A%20%3C%E5%88%97%E5%90%8D%3E%20%3C%E6%AF%94%E8%BE%83%E7%AC%A6%3E%20ALL%20%28%3C%E5%AD%90%E6%9F%A5%E8%AF%A2%3E%29%0A%E5%8A%9F%E8%83%BD%EF%BC%9A%3C%E5%AD%90%E6%9F%A5%E8%AF%A2%3E%E6%98%AF%E4%B8%80%E6%9D%A1%E5%AE%8C%E6%95%B4%E7%9A%84SELECT%E8%AF%AD%E5%8F%A5%EF%BC%8C%E8%A2%AB%E5%B5%8C%E5%A5%97%E5%9C%A8%E8%AF%A5%E6%AF%94%E8%BE%83%E5%BC%8F%E4%B8%AD%E4%BD%BF%E7%94%A8%E3%80%82%E5%BD%93%3C%E5%AD%90%E6%9F%A5%E8%AF%A2%3E%E7%9A%84%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%E7%9A%84%E6%AF%8F%E4%B8%80%E4%B8%AA%E5%80%BC%E9%83%BD%E6%BB%A1%E8%B6%B3%E6%89%80%E7%BB%99%E7%9A%84%E6%AF%94%E8%BE%83%E6%9D%A1%E4%BB%B6%E6%97%B6%EF%BC%8C%E6%AD%A4%E6%AF%94%E8%BE%83%E5%BC%8F%E7%9A%84%E5%80%BC%E6%89%8D%E4%B8%BA%E7%9C%9F%EF%BC%8C%E5%90%A6%E5%88%99%E4%B8%BA%E5%81%87%E3%80%82%E4%BE%8B%2017%20%E4%BB%8E%E5%95%86%E5%93%81%E8%A1%A81%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%8D%95%E4%BB%B7%E6%AF%94%E5%88%86%E7%B1%BB%E5%90%8D%E4%B8%BA%E2%80%9C%E6%B4%97%E8%A1%A3%E6%9C%BA%E2%80%9D%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E7%9A%84%E5%8D%95%E4%BB%B7%E9%83%BD%E9%AB%98%E7%9A%84%E5%95%86%E5%93%81%E3%80%82Select%20%2A%0AFrom%20%E5%95%86%E5%93%81%E8%A1%A81%0AWhere%20%E5%8D%95%E4%BB%B7%3Eall%20%28select%20%E5%8D%95%E4%BB%B7%20from%20%E5%95%86%E5%93%81%E8%A1%A81%20where%20%E5%88%86%E7%B1%BB%E5%90%8D%3D%E2%80%9C%E6%B4%97%E8%A1%A3%E6%9C%BA%E2%80%9D%E4%BE%8B%2018%20%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%95%B0%E9%87%8F%E5%B0%8F%E4%BA%8E%E5%88%86%E7%B1%BB%E5%90%8D%E4%B8%BA%E2%80%9C%E6%B4%97%E8%A1%A3%E6%9C%BA%E2%80%9D%E6%88%96%E2%80%9C%E5%BE%AE%E6%B3%A2%E7%82%89%E2%80%9D%E7%9A%84%E6%AF%8F%E4%B8%80%E4%B8%AA%E5%95%86%E5%93%81%E6%95%B0%E9%87%8F%E7%9A%84%E6%89%80%E6%9C%89%E5%85%83%E7%BB%84%28%E5%8C%85%E6%8B%AC%20%E4%BA%A7%E5%9C%B0%E5%92%8C%E5%93%81%E7%89%8C%29Select%20x.%2A%2C%E4%BA%A7%E5%9C%B0%2C%E5%93%81%E7%89%8C%0AFrom%20%E5%95%86%E5%93%81%E8%A1%A81%20x%20inner%20join%20%E5%95%86%E5%93%81%E8%A1%A82%20y%20on%20x.%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%3Dy.%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7Where%20%E6%95%B0%E9%87%8F%3Call%20%28select%20%E6%95%B0%E9%87%8F%20from%20%E5%95%86%E5%93%81%E8%A1%A81%20where%20%E5%88%86%E7%B1%BB%E5%90%8D%3D%E2%80%98%E6%B4%97%E8%A1%A3%E6%9C%BA%E2%80%99or%20%E5%88%86%E7%B1%BB%E5%90%8D%3D%E2%80%98%E5%BE%AE%E6%B3%A2%E7%82%89%E2%80%99%29%E6%A0%BC%E5%BC%8F2%20%3C%E5%88%97%E5%90%8D%3E%3C%E6%AF%94%E8%BE%83%E7%AC%A6%3E%7BANY%7CSOME%7D%28%3C%E5%AD%90%E6%9F%A5%E8%AF%A2%3E%29%E5%BD%93%E5%AD%90%E6%9F%A5%E8%AF%A2%E7%9A%84%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%E7%9A%84%E4%BB%BB%E4%B8%80%E4%B8%AA%E5%80%BC%E6%BB%A1%E8%B6%B3%E6%89%80%E7%BB%99%E7%9A%84%E6%AF%94%E8%BE%83%E6%9D%A1%E4%BB%B6%E6%97%B6%EF%BC%8C%E6%AD%A4%E6%AF%94%E8%BE%83%E5%BC%8F%E4%B8%BA%E7%9C%9F%EF%BC%8C%E5%90%A6%E5%88%99%E4%B8%BA%E5%81%87%E3%80%82%E8%AF%A5%E6%A0%BC%E5%BC%8F%E4%B8%AD%E7%9A%84%E4%B8%A4%E4%B8%AA%E5%85%B3%E9%94%AE%E5%AD%97ANY%E5%92%8CSOME%E5%85%B7%E6%9C%89%E5%90%8C%E6%A0%B7%E7%9A%84%E4%BD%9C%E7%94%A8%EF%BC%8C%E9%80%89%E7%94%A8%E4%BB%BB%E4%B8%80%E4%B8%AA%E5%8D%B3%E5%8F%AF%E3%80%82%E4%BE%8B%2019%20%E4%BB%8E%E5%95%86%E5%93%81%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E4%BA%A7%E5%9C%B0%E4%B8%8E%E5%93%81%E7%89%8C%E4%B8%BA%E2%80%9C%E6%98%A5%E5%85%B0%E2%80%9D%E7%9A%84%E5%95%86%E5%93%81%E7%9A%84%E4%BA%A7%E5%9C%B0%E7%9B%B8%E5%90%8C%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E7%9A%84%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%E3%80%81%E5%88%86%E7%B1%BB%E5%90%8D%E3%80%81%E5%93%81%E7%89%8C%E3%80%81%E4%BA%A7%E5%9C%B0%E7%AD%89%E5%B1%9E%E6%80%A7%E7%9A%84%E5%80%BC%0ASelect%20x.%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%2C%E5%88%86%E7%B1%BB%E5%90%8D%2C%E5%93%81%E7%89%8C%2C%E4%BA%A7%E5%9C%B0%0AFrom%20%E5%95%86%E5%93%81%E8%A1%A81%20x%20inner%20join%20%E5%95%86%E5%93%81%E8%A1%A82%20x%20on%20x.%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%3Dy.%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7Where%20%E4%BA%A7%E5%9C%B0%3Dsome%20%28select%20%E4%BA%A7%E5%9C%B0%20from%20%E5%95%86%E5%93%81%E8%A1%A82%20where%20%E5%93%81%E7%89%8C%3D%E2%80%98%E6%98%A5%E5%85%B0%E2%80%99%29%E4%BE%8B%2020%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E9%80%89%E4%BF%AE%E4%BA%86%E8%AF%BE%E7%A8%8B%E5%90%8D%E4%B8%BA%E2%80%9CC%2B%2B%E8%AF%AD%E8%A8%80%E2%80%9D%E7%9A%84%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9F%E7%9A%84%E5%A7%93%E5%90%8D%E5%92%8C%E6%88%90%E7%BB%A9%E3%80%82%E7%AC%AC%E4%B8%80%E7%A7%8D%E6%96%B9%E6%B3%95%EF%BC%9A%E4%BD%BF%E7%94%A8%E5%8D%95%E9%87%8D%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E5%A4%84%E7%90%86select%20%E5%A7%93%E5%90%8D%2C%E6%88%90%E7%BB%A9%0Afrom%20%E5%AD%A6%E7%94%9F%20x%2C%E8%AF%BE%E7%A8%8B%20y%2C%E9%80%89%E8%AF%BE%20z%0Awhere%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dz.%E5%AD%A6%E7%94%9F%E5%8F%B7%20and%20y.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3Dz.%E8%AF%BE%E7%A8%8B%E5%8F%B7%E7%AC%AC%E4%BA%8C%E7%A7%8D%E6%96%B9%E6%B3%95%EF%BC%9A%E4%BD%BF%E7%94%A8%E5%8F%8C%E9%87%8D%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E5%A4%84%E7%90%86select%20%E5%A7%93%E5%90%8D%2C%E6%88%90%E7%BB%A9%0Afrom%20%E5%AD%A6%E7%94%9F%20inner%20join%20%E9%80%89%E8%AF%BE%20on%20%E5%AD%A6%E7%94%9F.%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E5%AD%A6%E7%94%9F%E5%8F%B7where%20%E8%AF%BE%E7%A8%8B%E5%8F%B7%3Dsome%28select%20%E8%AF%BE%E7%A8%8B%E5%8F%B7from%20%E8%AF%BE%E7%A8%8B%3D%E2%80%98C%2B%2B%E8%AF%AD%E8%A8%80%E2%80%99%20%29%E4%BE%8B%2021%20%E4%BB%8E%E5%95%86%E5%93%81%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E4%B8%AD%E5%8D%95%E4%BB%B7%E6%9C%80%E9%AB%98%E7%9A%84%E5%95%86%E5%93%81%E5%92%8C%E5%8D%95%E4%BB%B7%E6%9C%80%E4%BD%8E%E7%9A%84%E5%95%86%E5%93%81Select%20%2AFrom%20%E5%95%86%E5%93%81%E8%A1%A81%0AWhere%20%E5%8D%95%E4%BB%B7%3Dany%28select%20max%28%E5%8D%95%E4%BB%B7%29%20from%20%E5%95%86%E5%93%81%E8%A1%A81%29%20or%20%E5%8D%95%E4%BB%B7%3Dany%28select%20min%28%E5%8D%95%E4%BB%B7%29%20from%20%E5%95%86%E5%93%81%E8%A1%A81%29%E6%88%96%EF%BC%9Aselect%20%2Afrom%20%E5%95%86%E5%93%81%E8%A1%A81%0Awhere%20%E5%8D%95%E4%BB%B7%3Dany%28select%20max%28%E5%8D%95%E4%BB%B7%29%20from%20%E5%95%86%E5%93%81%E8%A1%A81union%20select%20min%28%E5%8D%95%E4%BB%B7%29%20from%20%E5%95%86%E5%93%81%E8%A1%A81%29%E6%A0%BC%E5%BC%8F3%EF%BC%9A%20%3C%E5%88%97%E5%90%8D%3E%20%5BNOT%5D%20BETWEEN%20%3C%E5%BC%80%E5%A7%8B%E5%80%BC%3E%20AND%20%3C%E7%BB%93%E6%9D%9F%E5%80%BC%3E%E4%BE%8B%2022%20%E4%BB%8E%E5%95%86%E5%93%81%E8%A1%A81%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%8D%95%E4%BB%B7%E5%9C%A81000%E5%88%B02000%E5%85%83%E4%B9%8B%E9%97%B4%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81Select%20%2AFrom%20%E5%95%86%E5%93%81%E8%A1%A81%0AWhere%20%E5%8D%95%E4%BB%B7%20between%201000%20and%202000%E6%A0%BC%E5%BC%8F4%EF%BC%9A%20%3CNOT%3E%20EXISTS%20%28%3C%E5%AD%90%E6%9F%A5%E8%AF%A2%3E%29%0A%E5%BD%93%E5%AD%90%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%E8%87%B3%E5%B0%91%E5%AD%98%E5%9C%A8%E7%9D%80%E4%B8%80%E4%B8%AA%E5%85%83%E7%BB%84%E6%97%B6%EF%BC%8C%E8%A1%A8%E6%98%8E%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E9%9D%9E%E7%A9%BA%EF%BC%8C%E5%88%99%E6%AD%A4%E5%88%A4%E6%96%AD%E5%BC%8F%E4%B8%BA%E7%9C%9F%EF%BC%8C%E5%90%A6%E5%88%99%E4%B8%BA%E5%81%87%E3%80%82%E4%BD%86%E5%BD%93%E5%88%A4%E6%96%AD%E5%BC%8F%E4%B8%AD%E5%B8%A6%E6%9C%89NOT%E5%85%B3%E9%94%AE%E5%AD%97%E6%97%B6%EF%BC%8C%E6%83%85%E5%86%B5%E6%AD%A3%E5%A5%BD%E7%9B%B8%E5%8F%8D%EF%BC%8C%E5%8D%B3%E5%BD%93%E5%AD%90%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%BA%E7%A9%BA%E6%97%B6%EF%BC%8C%E5%88%A4%E6%96%AD%E5%BC%8F%E4%B8%BA%E7%9C%9F%EF%BC%8C%E5%90%A6%E5%88%99%E4%B8%BA%E5%81%87%E3%80%82%E4%BE%8B%2023%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E9%80%89%E4%BF%AE%E8%87%B3%E5%B0%91%E4%B8%80%E9%97%A8%E8%AF%BE%E7%A8%8B%E7%9A%84%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9FSelect%20%2A%0AFrom%20%E5%AD%A6%E7%94%9F%0AWhere%20exists%20%28select%20%2A%20from%20%E9%80%89%E8%AF%BE%20where%20%E5%AD%A6%E7%94%9F.%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E5%AD%A6%E7%94%9F%E5%8F%B7%29%E4%BE%8B%2024%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E4%B8%8E%E5%A7%93%E5%90%8D%E4%B8%BA%E2%80%9C%E7%8E%8B%E6%98%8E%E2%80%9D%E7%9A%84%E5%AD%A6%E7%94%9F%E9%80%89%E8%AF%BE%E8%87%B3%E5%B0%91%E6%9C%89%E4%B8%80%E9%97%A8%E7%9B%B8%E5%90%8C%E7%9A%84%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9FSelect%20%2AFrom%20%E5%AD%A6%E7%94%9F%20x%0AWhere%20x.%E5%A7%93%E5%90%8D%3C%3E%E2%80%98%E7%8E%8B%E6%98%8E%E2%80%99%20and%20exists%20%28select%20y.%E8%AF%BE%E7%A8%8B%E5%8F%B7%20from%20%E9%80%89%E8%AF%BE%20ywhere%20y.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dx.%E5%AD%A6%E7%94%9F%E5%8F%B7%20and%20y.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3Dany%28select%20w.%E8%AF%BE%E7%A8%8B%E5%8F%B7from%20%E5%AD%A6%E7%94%9F%20z%EF%BC%8C%E9%80%89%E8%AF%BE%20w%20where%20z.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dw.%E5%AD%A6%E7%94%9F%E5%8F%B7%20and%20z.%E5%A7%93%E5%90%8D%3D%E2%80%98%E7%8E%8B%E6%98%8E%E2%80%99%29%29%E6%A0%BC%E5%BC%8F5%EF%BC%9A%3C%E5%88%97%E5%90%8D%3E%20%5BNOT%5D%20IN%20%7B%28%3C%E5%B8%B8%E9%87%8F%E8%A1%A8%3E%29%20%7C%20%28%3C%E5%AD%90%E6%9F%A5%E8%AF%A2%3E%29%7D%3C%E5%B8%B8%E9%87%8F%E8%A1%A8%3E%E4%BD%BF%E7%94%A8%E9%80%97%E5%8F%B7%E5%88%86%E5%BC%80%E7%9A%84%E8%8B%A5%E5%B9%B2%E4%B8%AA%E5%B8%B8%E9%87%8F%E3%80%82%E5%BD%93%3C%E5%88%97%E5%90%8D%3E%E6%89%80%E5%88%B6%E5%AE%9A%E5%88%97%E7%9A%84%E5%BD%93%E5%89%8D%E5%80%BC%E5%8C%85%E6%8B%AC%E5%9C%A8%E7%94%B1%3C%E5%B8%B8%E9%87%8F%E8%A1%A8%3E%E6%89%80%E7%BB%99%E5%AE%9A%E7%9A%84%E5%80%BC%E4%B9%8B%E5%86%85%E6%97%B6%EF%BC%8C%E5%88%99%E6%AD%A4%E5%88%A4%E6%96%AD%E5%BC%8F%E4%B8%BA%E7%9C%9F%EF%BC%8C%E5%90%A6%E5%88%99%E4%B8%BA%E5%81%87%E3%80%82%E4%BE%8B%2026%20%E4%BB%8E%E5%AD%A6%E7%94%9F%E8%A1%A8%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E4%B8%93%E4%B8%9A%E4%B8%BA%E8%AE%A1%E7%AE%97%E6%9C%BA%E3%80%81%E7%94%B5%E6%B0%94%E3%80%81%E9%80%9A%E4%BF%A1%E7%9A%84%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9F%E3%80%82Select%20%2A%0AFrom%20%E5%AD%A6%E7%94%9F%0AWhere%20%E4%B8%93%E4%B8%9A%20in%20%28%E2%80%98%E8%AE%A1%E7%AE%97%E6%9C%BA%E2%80%99%2C%E2%80%98%E7%94%B5%E6%B0%94%E2%80%99%2C%E2%80%98%E9%80%9A%E4%BF%A1%E2%80%99%29%E4%BE%8B%2027%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E9%80%89%E4%BF%AE%E4%BA%86%E8%AF%BE%E7%A8%8B%E5%90%8D%E4%B8%BA%E2%80%9C%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E2%80%9D%E7%9A%84%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9F%E3%80%82Select%20%2AFrom%20%E5%AD%A6%E7%94%9F%0AWhere%20%E5%AD%A6%E7%94%9F%E5%8F%B7%20in%20%28select%20%E5%AD%A6%E7%94%9F%E5%8F%B7from%20%E9%80%89%E8%AF%BE%2C%E8%AF%BE%E7%A8%8B%0Awhere%20%E9%80%89%E8%AF%BE.%E8%AF%BE%E7%A8%8B%E5%8F%B7%3D%E8%AF%BE%E7%A8%8B.%E8%AF%BE%E7%A8%8B%E5%8F%B7%20and%20%E8%AF%BE%E7%A8%8B%E5%90%8D%3D%E2%80%98%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E2%80%99%29%20%E6%A0%BC%E5%BC%8F6%EF%BC%9A%3C%E5%AD%97%E7%AC%A6%E5%9E%8B%E5%88%97%E5%90%8D%3E%20%5BNOT%20%5D%20%3C%E5%AD%97%E7%AC%A6%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%E5%BD%93%3C%E5%AD%97%E7%AC%A6%E5%9E%8B%E5%88%97%E5%90%8D%3E%E7%9A%84%E5%BD%93%E5%89%8D%E5%80%BC%E4%B8%8E%3C%E5%AD%97%E7%AC%A6%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%E7%9A%84%E5%80%BC%E7%9B%B8%E5%8C%B9%E9%85%8D%E6%97%B6%EF%BC%8C%E6%AD%A4%E5%88%A4%E6%96%AD%E6%97%B6%E4%B8%BA%E7%9C%9F%E3%80%82%E4%BE%8B%2028%20%E4%BB%8E%E5%95%86%E5%93%81%E8%A1%A81%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%E4%BB%A5%E5%AD%97%E7%AC%A6%E4%B8%B2%E2%80%9Cdsj%E2%80%9D%E5%BC%80%E5%A4%B4%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81Select%20%2AFrom%20%E5%95%86%E5%93%81%E8%A1%A81%0AWhere%20%E5%95%86%E5%93%81%E4%BB%A3%E5%8F%B7%20like%20%E2%80%98dsj%25%E2%80%995%E3%80%81GROUP%20BY%E9%80%89%E9%A1%B9%0A%E8%AF%A5%E9%80%89%E9%A1%B9%E4%B8%AD%E7%9A%84%3C%E5%88%86%E7%BB%84%E5%88%97%E5%90%8D1%3E%2C%3C%E5%88%86%E7%BB%84%E5%88%97%E5%90%8D2%3E%E7%AD%89%E5%BF%85%E9%A1%BB%E6%98%AF%E5%87%BA%E7%8E%B0%E5%9C%A8SELECT%E9%80%89%E9%A1%B9%E4%B8%AD%E7%9A%84%E8%A2%AB%E6%8A%95%E5%BD%B1%E7%9A%84%E8%A1%A8%E8%BE%BE%E5%BC%8F%E6%89%80%E6%8C%87%E5%AE%9A%E7%9A%84%E5%88%97%E5%90%8D%E3%80%82%E9%80%9A%E5%B8%B8%E5%9C%A8SELECT%E9%80%89%E9%A1%B9%E4%B8%AD%E4%BD%BF%E7%94%A8%E5%88%97%E5%87%BD%E6%95%B0%E5%AF%B9%E5%88%97%E5%80%BC%E7%9B%B8%E5%90%8C%E7%9A%84%E6%AF%8F%E4%B8%80%E7%BB%84%E8%BF%9B%E8%A1%8C%E6%9C%89%E5%85%B3%E7%BB%9F%E8%AE%A1%E4%BE%8B%2029%20%E4%BB%8E%E5%AD%A6%E7%94%9F%E8%A1%A8%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%AF%8F%E4%B8%AA%E4%B8%93%E4%B8%9A%E7%9A%84%E5%AD%A6%E7%94%9F%E6%95%B0Select%20%E4%B8%93%E4%B8%9A%20%E4%B8%93%E4%B8%9A%E5%90%8D%2Ccount%28%E4%B8%93%E4%B8%9A%29%20%E5%AD%A6%E7%94%9F%E6%95%B0From%20%E5%AD%A6%E7%94%9F%0AGroup%20by%20%E4%B8%93%E4%B8%9A%0A%E4%BE%8B%2030%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%AF%8F%E4%B8%AA%E5%AD%A6%E7%94%9F%E7%9A%84%E5%AD%A6%E7%94%9F%E5%8F%B7%EF%BC%8C%E5%A7%93%E5%90%8D%E5%8F%8A%E6%89%80%E9%80%89%E8%AF%BE%E7%A8%8B%E7%9A%84%E9%97%A8%E6%95%B0Select%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E5%A7%93%E5%90%8D%2Ccount%28x.%E5%AD%A6%E7%94%9F%E5%8F%B7%29%20%E6%89%80%E9%80%89%E9%97%A8%E6%95%B0From%20%E9%80%89%E8%AF%BE%20x%20%2C%E5%AD%A6%E7%94%9F%20yWhere%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dy.%E5%AD%A6%E7%94%9F%E5%8F%B7Group%20by%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%2Cy.%E5%A7%93%E5%90%8D%0A%E4%BE%8B%2031%20%E4%BB%8E%E5%95%86%E5%93%81%E8%A1%A81%E7%A7%8D%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%AF%8F%E4%B8%80%E7%B1%BB%EF%BC%88%E5%8D%B3%E5%88%86%E7%B1%BB%E5%90%8D%E7%9B%B8%E5%90%8C%EF%BC%89%E5%95%86%E5%93%81%E7%9A%84%E6%9C%80%E9%AB%98%E4%BB%B7%E3%80%81%E6%9C%80%E4%BD%8E%E4%BB%B7%E5%92%8C%E5%B9%B3%E5%9D%87%E4%BB%B7%E3%80%82%0ASelect%20%E5%88%86%E7%B1%BB%E5%90%8D%2Cmax%28%E5%8D%95%E4%BB%B7%29%20as%20%E6%9C%80%E9%AB%98%E4%BB%B7%2Cmin%28%E5%8D%95%E4%BB%B7%29%20as%20%E6%9C%80%E4%BD%8E%E4%BB%B7%2Cavg%28%E5%8D%95%E4%BB%B7%29%20as%20%E5%B9%B3%E5%9D%87%E4%BB%B7From%20%E5%95%86%E5%93%81%E8%A1%A81Group%20by%20%E5%88%86%E7%B1%BB%E5%90%8D6%E3%80%81HAVING%20%E9%80%89%E9%A1%B9%0A%E8%AF%A5%E9%80%89%E9%A1%B9%E7%9A%84%3C%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F%3E%E6%98%AF%E4%B8%80%E4%B8%AA%E7%AD%9B%E9%80%89%E6%9D%A1%E4%BB%B6%E3%80%82%E8%AF%A5%E9%80%89%E9%A1%B9%E9%80%9A%E5%B8%B8%E8%B7%9F%E5%9C%A8GROUP%20BY%E5%AD%90%E5%8F%A5%E5%90%8E%E9%9D%A2%E7%94%A8%E6%9D%A5%E4%BB%8E%E5%88%86%E7%BB%84%E7%BB%9F%E8%AE%A1%E4%B8%AD%E7%AD%9B%E9%80%89%E5%87%BA%E9%83%A8%E5%88%86%E7%BB%9F%E8%AE%A1%E7%BB%93%E6%9E%9C%EF%BC%8C%E5%9B%A0%E6%AD%A4%E8%AF%A5%E9%80%89%E9%A1%B9%E4%B8%AD%E7%9A%84%E9%80%BB%E8%BE%91%E8%A1%A8%E8%BE%BE%E5%BC%8F%E9%80%9A%E5%B8%B8%E5%B8%A6%E6%9C%89%E5%AD%97%E6%AE%B5%E5%87%BD%E6%95%B0%E4%BE%8B%2032%20%E4%BB%8E%E5%AD%A6%E7%94%9F%E8%A1%A8%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E4%B8%93%E4%B8%9A%E7%9A%84%E5%AD%A6%E7%94%9F%E6%95%B0%E5%A4%9A%E4%BA%8E1%E4%BA%BA%E7%9A%84%E4%B8%93%E4%B8%9A%E5%90%8D%E5%8F%8A%E4%BA%BA%E6%95%B0Select%20%E4%B8%93%E4%B8%9A%20as%20%E4%B8%93%E4%B8%9A%E5%90%8D%2Ccount%28%E4%B8%93%E4%B8%9A%29%20as%20%E5%AD%A6%E7%94%9F%E6%95%B0From%20%E5%AD%A6%E7%94%9FGroup%20by%20%E4%B8%93%E4%B8%9A%0AHaving%20count%28%E4%B8%93%E4%B8%9A%29%3E1%0A%E4%BE%8B%2033%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E9%80%89%E4%BF%AE%E8%AF%BE%E7%A8%8B%E8%B6%85%E8%BF%871%E9%97%A8%E7%9A%84%E5%AD%A6%E7%94%9F%E3%80%82Select%20%2AFrom%20%E5%AD%A6%E7%94%9F%0AWhere%20%E5%AD%A6%E7%94%9F%E5%8F%B7%20in%20%28select%20%E5%AD%A6%E7%94%9F%E5%8F%B7from%20%E9%80%89%E8%AF%BEgroup%20by%20%E5%AD%A6%E7%94%9F%E5%8F%B7%20having%20count%28%E5%AD%A6%E7%94%9F%E5%8F%B7%29%3E1%29%0A%E4%BE%8B%2034%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0%E8%B6%85%E8%BF%87%E5%AD%A6%E7%94%9F%E5%8F%B7%E4%B8%BA0101001%E5%AD%A6%E7%94%9F%E7%9A%84%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0%E7%9A%84%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9F%E3%80%82Select%20%2AFrom%20%E5%AD%A6%E7%94%9F%0AWhere%20%E5%AD%A6%E7%94%9F%E5%8F%B7%20in%20%28select%20%E5%AD%A6%E7%94%9F%E5%8F%B7from%20%E9%80%89%E8%AF%BE%0Agroup%20by%20%E5%AD%A6%E7%94%9F%E5%8F%B7%20having%20count%28%E5%AD%A6%E7%94%9F%E5%8F%B7%29%3E%28select%20count%28%2A%29from%20%E9%80%89%E8%AF%BE%0Awhere%20%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E2%80%980101001%E2%80%99%29%29%0A7%E3%80%81ORDER%20BY%20%E9%80%89%E9%A1%B9%0A%E6%AD%A4%E9%80%89%E9%A1%B9%E4%B8%AD%E7%9A%84%3C%E6%8E%92%E5%BA%8F%E5%88%97%E5%90%8D1%3E%2C%3C%E6%8E%92%E5%BA%8F%E5%88%97%E5%90%8D2%3E%E7%AD%89%E6%98%AF%E9%9C%80%E8%A6%81%E6%98%AF%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E6%8C%89%E5%85%B6%E8%BF%9B%E8%A1%8C%E6%8E%92%E5%BA%8F%E7%9A%84%E5%88%97%E3%80%82%E4%BB%96%E4%BB%AC%E5%8F%AF%E4%BB%A5%E6%98%AF%E5%8E%9F%E8%A1%A8%E4%B8%AD%E7%9A%84%E5%88%97%E5%90%8D%EF%BC%8C%E4%B9%9F%E5%8F%AF%E4%BB%A5%E6%98%AFSELECT%E9%80%89%E9%A1%B9%E4%B8%AD%E6%89%80%E7%BB%99%E8%A1%A8%E8%BE%BE%E5%BC%8F%E7%9A%84%E9%A1%BA%E5%BA%8F%E5%8F%B7%EF%BC%88%E5%8D%B3%E5%AF%B9%E5%BA%94%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%B8%AD%E7%9A%84%E5%88%97%E5%8F%B7%EF%BC%89%E6%88%96%E5%AE%9A%E4%B9%89%E7%9A%84%E5%88%97%E5%90%8D%E3%80%82%E8%8B%A5%E5%85%B6%E5%90%8E%E5%B8%A6%E6%9C%89ASC%E5%85%B3%E9%94%AE%E5%AD%97%EF%BC%8C%E5%88%99%E5%B0%86%E6%8C%89%E5%80%BC%E7%9A%84%E5%8D%87%E5%BA%8F%E6%8E%92%E5%BA%8F%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%EF%BC%8C%E8%8B%A5%E5%85%B6%E5%90%8E%E5%B8%A6%E6%9C%89DESC%E5%85%B3%E9%94%AE%E5%AD%97%EF%BC%8C%E5%88%99%E5%B0%86%E6%8C%89%E5%80%BC%E7%9A%84%E9%99%8D%E5%BA%8F%E6%8E%92%E5%BA%8F%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%EF%BC%8C%E8%8B%A5%E4%B8%8D%E6%8C%87%E5%AE%9A%E6%8E%92%E5%BA%8F%E6%96%B9%E5%BC%8F%EF%BC%8C%E5%88%99%E9%BB%98%E8%AE%A4%E6%8C%89%E5%8D%87%E5%BA%8F%E6%8E%92%E5%BA%8F%E3%80%82%E6%B3%A8%E6%84%8F%EF%BC%9A%E8%AF%A5%E9%80%89%E9%A1%B9%E5%8F%AA%E8%83%BD%E7%94%A8%E5%9C%A8%E6%9C%80%E5%A4%96%E5%B1%82%E7%9A%84%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E4%B8%AD%EF%BC%8C%E4%B8%8D%E8%83%BD%E5%9C%A8%E5%AD%90%E6%9F%A5%E8%AF%A2%E4%B8%AD%E4%BD%BF%E7%94%A8%E3%80%82%E4%BE%8B%2035%20%E4%BB%8E%E5%95%86%E5%93%81%E8%A1%A8%E4%B8%AD%E6%8C%89%E5%8D%95%E4%BB%B7%E5%8D%87%E5%BA%8F%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%E8%AE%B0%E5%BD%95%E3%80%82Select%20%2A%0AFrom%20%E5%95%86%E5%93%81%E8%A1%A81Order%20by%20%E5%8D%95%E4%BB%B7%0A%E4%BE%8B%2036%20%E4%BB%8E%E5%95%86%E5%93%81%E8%A1%A81%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E5%8D%95%E4%BB%B7%E6%AF%94%E5%B9%B3%E5%9D%87%E5%8D%95%E4%BB%B7%E9%AB%98%E7%9A%84%E6%89%80%E6%9C%89%E5%95%86%E5%93%81%EF%BC%8C%E5%B9%B6%E4%BD%BF%E7%BB%93%E6%9E%9C%E6%8C%89%E9%99%8D%E5%BA%8F%E6%8E%92%E5%88%97%E3%80%82Select%20%2AFrom%20%E5%95%86%E5%93%81%E8%A1%A81%0AWhere%20%E5%8D%95%E4%BB%B7%3Eall%20%28select%20avg%28%E5%8D%95%E4%BB%B7%29%20from%20%E5%95%86%E5%93%81%E8%A1%A81%29Order%20by%20%E5%8D%95%E4%BB%B7%20desc%E4%BE%8B%2037%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9F%E7%9A%84%E5%AD%A6%E5%8F%B7%E5%8F%8A%E6%89%80%E9%80%89%E8%AF%BE%E7%A8%8B%E7%9A%84%E9%97%A8%E6%95%B0%EF%BC%8C%E6%8C%89%E9%97%A8%E6%95%B0%E5%8D%87%E5%BA%8F%E6%8E%92%E5%88%97%E7%BB%93%E6%9E%9C%0ASelect%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%2Ccount%28x.%E5%AD%A6%E7%94%9F%E5%8F%B7%29%20as%20%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0From%20%E5%AD%A6%E7%94%9F%20x%2C%E9%80%89%E8%AF%BE%20yWhere%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dy.%E5%AD%A6%E7%94%9F%E5%8F%B7Group%20by%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7Order%20by%20%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0%E4%BE%8B%2038%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%89%80%E6%9C%89%E5%AD%A6%E7%94%9F%E7%9A%84%E4%BF%A1%E6%81%AF%E5%8F%8A%E6%89%80%E9%80%89%E8%AF%BE%E7%A8%8B%E7%9A%84%E9%97%A8%E6%95%B0%EF%BC%8C%E6%8C%89%E9%97%A8%E6%95%B0%E5%8D%87%E5%BA%8F%E6%8E%92%E5%88%97%E7%BB%93%E6%9E%9C%E3%80%82Select%20x.%2A%2Ccount%28x.%E5%AD%A6%E7%94%9F%E5%8F%B7%29%20as%20%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0From%20%E5%AD%A6%E7%94%9F%20x%2C%E9%80%89%E8%AF%BE%20yWhere%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%3D%E9%80%89%E8%AF%BE.%E5%AD%A6%E7%94%9F%E5%8F%B7Group%20by%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%2C%E5%A7%93%E5%90%8D%2C%E6%80%A7%E5%88%AB%2C%E4%B8%93%E4%B8%9AOrder%20by%20%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B08%E3%80%81INTO%20%E9%80%89%E9%A1%B9%0A%E6%AD%A4%E9%80%89%E9%A1%B9%E8%83%BD%E5%A4%9F%E6%A0%B9%E6%8D%AE%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E8%87%AA%E5%8A%A8%E5%BB%BA%E7%AB%8B%E4%B8%80%E4%B8%AA%E5%9F%BA%E6%9C%AC%E8%A1%A8%EF%BC%8C%E9%80%9A%E5%B8%B8%E4%BD%9C%E4%B8%BA%E4%B8%B4%E6%97%B6%E8%A1%A8%E4%BD%BF%E7%94%A8%EF%BC%8C%E5%8F%AF%E4%BB%A5%E6%A0%B9%E6%8D%AE%E9%9C%80%E8%A6%81%E4%BB%BB%E6%84%8F%E5%BB%BA%E7%AB%8B%E5%92%8C%E5%88%A0%E9%99%A4%E3%80%82%E4%BE%8B%2039%20%E4%BB%8E%E6%95%99%E5%AD%A6%E5%BA%93%E4%B8%AD%E6%9F%A5%E8%AF%A2%E5%87%BA%E6%AF%8F%E4%B8%AA%E5%AD%A6%E7%94%9F%E7%9A%84%E5%AD%A6%E7%94%9F%E5%8F%B7%E3%80%81%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0%E5%92%8C%E6%80%BB%E6%88%90%E7%BB%A9%EF%BC%8C%E6%8A%8A%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E4%BF%9D%E5%AD%98%E5%88%B0%E5%AD%A6%E7%94%9F%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0%E5%8F%8A%E6%80%BB%E6%88%90%E7%BB%A9%E7%BB%9F%E8%AE%A1%E8%A1%A8%E4%B8%AD%E3%80%82Select%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%2Ccount%28x.%E5%AD%A6%E7%94%9F%E5%8F%B7%29%20as%20%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0%2Csum%28%E6%88%90%E7%BB%A9%29%20as%20%E6%80%BB%E6%88%90%E7%BB%A9into%20%E5%AD%A6%E7%94%9F%E9%80%89%E8%AF%BE%E9%97%A8%E6%95%B0%E5%8F%8A%E6%80%BB%E6%88%90%E7%BB%A9%E7%BB%9F%E8%AE%A1%E8%A1%A8From%20%E5%AD%A6%E7%94%9Fx%2C%E9%80%89%E8%AF%BE%20y%0AWhere%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%3Dy.%E5%AD%A6%E7%94%9F%E5%8F%B7Group%20by%20x.%E5%AD%A6%E7%94%9F%E5%8F%B7%E6%9C%AC%E7%AB%A0%E5%B0%8F%E7%BB%93%0A%E2%96%BA%20SQL%E6%98%AF%E5%9B%BD%E9%99%85%E9%80%9A%E7%94%A8%E7%9A%84%E5%85%B3%E7%B3%BB%E6%95%B0%E6%8D%AE%E5%BA%93%E6%9F%A5%E8%AF%A2%E8%AF%AD%E8%A8%80%EF%BC%8C%E5%87%A0%E4%B9%8E%E8%A2%AB%E6%AF%8F%E4%B8%80%E7%A7%8D%E5%AE%9E%E9%99%85%E7%9A%84%E5%85%B3%E7%B3%BB%E6%95%B0%E6%8D%AE%E5%BA%93%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F%E6%89%80%E9%87%87%E7%94%A8%EF%BC%8C%E5%90%84%E7%B3%BB%E7%BB%9F%E9%83%BD%E6%A0%B9%E6%8D%AE%E6%9C%AC%E8%BA%AB%E7%89%B9%E7%82%B9%E5%AF%B9%E5%85%B6%E8%BF%9B%E8%A1%8C%E4%BA%86%E4%BF%AE%E6%94%B9%E5%92%8C%E6%89%A9%E5%85%85%EF%BC%8C%E5%9C%A8%E4%B8%8D%E5%90%8C%E7%A8%8B%E5%BA%A6%E4%B8%8A%E5%A2%9E%E5%BC%BA%E4%BA%86%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86%E5%92%8C%E6%9C%89%E5%85%B3%E6%96%B9%E9%9D%A2%E7%9A%84%E5%8A%9F%E8%83%BD%E3%80%82%E2%96%BA%20%E4%B8%80%E4%B8%AA%E6%95%B0%E6%8D%AE%E5%BA%93%E7%94%B1%E5%9F%BA%E6%9C%AC%E8%A1%A8%E5%92%8C%E8%A7%86%E5%9B%BE%E7%AD%89%E7%BB%84%E6%88%90%EF%BC%8C%E6%AF%8F%E4%B8%AA%E5%9F%BA%E6%9C%AC%E8%A1%A8%E7%9A%84%E7%BB%93%E6%9E%84%E5%92%8C%E5%86%85%E5%AE%B9%E6%98%AF%E5%88%86%E5%88%AB%E5%BB%BA%E7%AB%8B%E7%9A%84%EF%BC%8C%E6%AF%8F%E4%B8%AA%E8%A7%86%E5%9B%BE%E6%98%AF%E6%A0%B9%E6%8D%AE%E7%9B%B8%E5%BA%94%E7%9A%84%E5%9F%BA%E6%9C%AC%E8%A1%A8%EF%BC%88%E4%B9%9F%E5%8F%AF%E4%BB%8D%E4%B8%BA%E8%A7%86%E5%9B%BE_%29%E8%80%8C%E5%BB%BA%E7%AB%8B%E7%9A%84%EF%BC%8C%E5%AE%83%E6%98%AF%E7%9B%B8%E5%BA%94%E8%A1%A8%E4%B8%AD%E7%9A%84%E4%B8%80%E4%BA%9B%E7%BB%93%E6%9E%84%E5%92%8C%E4%B8%80%E4%BA%9B%E8%A1%8C%E5%86%85%E5%AE%B9%E7%9A%84%E6%98%A0%E8%B1%A1%E3%80%82%E2%96%BA%20%E5%BB%BA%E7%AB%8B%E4%B8%80%E4%B8%AA%E5%9F%BA%E6%9C%AC%E8%A1%A8%E7%BB%93%E6%9E%84%EF%BC%8C%E5%B0%B1%E6%98%AF%E5%AE%9A%E4%B9%89%E8%A1%A8%E4%B8%AD%E5%8C%85%E5%90%AB%E7%9A%84%E6%AF%8F%E4%B8%AA%E5%88%97%EF%BC%8C%E9%9B%86%E4%B8%AD%E5%8C%85%E6%8B%AC%E5%88%97%E6%98%8E%E3%80%81%E7%B1%BB%E5%9E%8B%E3%80%81%E9%95%BF%E5%BA%A6%E3%80%81%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%E7%AD%89%E3%80%82%E5%BD%93%E8%A1%A8%E4%B8%AD%E7%9A%84%E4%B8%80%E4%B8%AA%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%E6%B6%89%E5%8F%8A%E5%88%B0%E5%A4%9A%E4%B8%AA%E5%88%97%E6%97%B6%EF%BC%8C%E5%88%99%E5%BF%85%E9%A1%BB%E5%9C%A8%E6%89%80%E6%9C%89%E5%88%97%E5%AE%9A%E4%B9%89%E4%B9%8B%E5%90%8E%E7%BB%99%E5%87%BA%E7%9B%B8%E5%BA%94%E7%9A%84%E8%A1%A8%E5%8F%8A%E5%AE%8C%E6%95%B4%E6%80%A7%E7%BA%A6%E6%9D%9F%E3%80%82%E2%96%BA%20SELECT%E6%9F%A5%E8%AF%A2%E8%AF%AD%E5%8F%A5%E5%85%B7%E6%9C%89%E4%B8%B0%E5%AF%8C%E7%9A%84%E6%95%B0%E6%8D%AE%E6%9F%A5%E8%AF%A2%E5%8A%9F%E8%83%BD%EF%BC%8C%E8%83%BD%E5%A4%9F%E5%AE%9E%E7%8E%B0%E5%85%B3%E7%B3%BB%E8%BF%90%E7%AE%97%E4%B8%AD%E7%9A%84%E5%A4%A7%E5%A4%9A%E6%95%B0%E8%BF%90%E7%AE%97%EF%BC%8C%E5%A6%82%E9%80%89%E6%8B%A9%E3%80%81%E6%8A%95%E5%BD%B1%E3%80%81%E8%BF%9E%E6%8E%A5%E3%80%81%E5%B9%B6%E7%AD%89%EF%BC%8C%E5%B9%B6%E4%B8%94%E8%BF%98%E5%B8%A6%E6%9C%89%E5%88%86%E7%BB%84%E3%80%81%E6%8E%92%E5%BA%8F%E3%80%81%E7%BB%9F%E8%AE%A1%E7%AD%89%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86%E5%8A%9F%E8%83%BD%E3%80%82%E9%9A%8F%E7%9D%80SQL%E7%89%88%E6%9C%AC%E7%9A%84%E4%B8%8D%E6%96%AD%E6%9B%B4%E6%96%B0%EF%BC%8C%E5%BF%85%E5%B0%86%E4%BC%9A%E5%A2%9E%E5%8A%A0%E8%B6%8A%E6%9D%A5%E8%B6%8A%E5%A4%9A%E7%9A%84%E6%95%B0%E6%8D%AE%E5%A4%84%E7%90%86%E5%8A%9F%E8%83%BD%E3%80%82%0A%E2%96%BA%20SELECT%20%E8%AF%AD%E5%8F%A5%E7%9A%84%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%E6%9C%89%E5%A4%9A%E7%A7%8D%E5%8F%AF%E8%83%BD%EF%BC%8C%E6%9C%89%E7%9A%84%E4%B8%BA%E7%A9%BA%EF%BC%8C%E6%9C%89%E7%9A%84%E4%B8%BA%E4%B8%80%E4%B8%AA%E5%8D%95%E5%80%BC%E5%85%83%E7%BB%84%EF%BC%8C%E6%9C%89%E7%9A%84%E4%B8%BA%E4%B8%80%E4%B8%AA%E5%A4%9A%E5%80%BC%EF%BC%88%E5%8D%B3%E5%90%AB%E6%9C%89%E5%A4%9A%E4%B8%AA%E5%88%97%EF%BC%89%E5%85%83%E7%BB%84%EF%BC%8C%E6%9C%89%E7%9A%84%E4%B8%BA%E5%8D%95%E5%80%BC%E7%9A%84%E5%A4%9A%E4%B8%AA%E5%85%83%E7%BB%84%EF%BC%8C%E6%9C%89%E7%9A%84%E4%B8%BA%E5%A4%9A%E5%80%BC%E7%9A%84%E5%A4%9A%E4%B8%AA%E5%85%83%E7%BB%84%E7%AD%89%E3%80%82%E8%8B%A5%E4%B8%BA%E5%8D%95%E5%80%BC%E5%85%83%E7%BB%84%E6%97%B6%EF%BC%8C%E6%AD%A4%E6%9F%A5%E8%AF%A2%E5%8F%AF%E4%BB%A5%E4%BD%9C%E4%B8%BA%E4%B8%80%E4%B8%AA%E6%95%B0%E6%8D%AE%E9%A1%B9%E5%87%BA%E7%8E%B0%E5%9C%A8%E4%BB%BB%E4%BD%95%E8%A1%A8%E8%BE%BE%E5%BC%8F%E4%B8%AD%E3%80%82%E2%96%BA%20SELECT%E8%AF%AD%E5%8F%A5%E5%8F%AF%E4%BB%A5%E4%BD%9C%E4%B8%BA%E4%B8%80%E4%B8%AA%E8%AF%AD%E5%8F%A5%E6%88%90%E5%88%86%EF%BC%88%E5%8D%B3%E5%AD%90%E6%9F%A5%E8%AF%A2%EF%BC%89%E5%87%BA%E7%8E%B0%E5%9C%A8%E5%90%84%E7%A7%8D%E8%AF%AD%E5%8F%A5%E4%B8%AD%E3%80%82%E8%8B%A5%E5%9C%A8SELECT%E8%AF%AD%E5%8F%A5%E7%9A%84WHERE%E9%80%89%E9%A1%B9%E4%B8%AD%E4%BB%8D%E4%BD%BF%E7%94%A8%E4%B8%80%E4%B8%AASELECT%E8%AF%AD%E5%8F%A5%EF%BC%8C%E5%88%99%E6%88%90%E4%B8%BASELECT%E8%AF%AD%E5%8F%A5%E7%9A%84%E5%B5%8C%E5%A5%97%EF%BC%8CSELECT%E8%AF%AD%E5%8F%A5%E5%8F%AF%E4%BB%A5%E5%B5%8C%E5%A5%97%E4%BB%BB%E6%84%8F%E6%B7%B1%E5%BA%A6%EF%BC%8C%E4%BD%86%E4%B8%80%E8%88%AC%E5%B5%8C%E5%A5%97%E4%B8%BA%E4%BA%8C%E8%87%B3%E4%B8%89%E5%B1%82%E3%80%82%E2%96%BA%20%E5%AD%A6%E4%B9%A0SQL%E8%BF%98%E8%A6%81%E9%9D%A0%E4%B8%8A%E6%9C%BA%E5%AE%9E%E8%B7%B5%EF%BC%8C%E4%B8%BA%E6%AD%A4%E9%9C%80%E8%A6%81%E9%92%88%E5%AF%B9%E5%85%B7%E4%BD%93%E7%9A%84%E5%85%B3%E7%B3%BB%E6%95%B0%E6%8D%AE%E5%BA%93%E7%AE%A1%E7%90%86%0A%E7%B3%BB%E7%BB%9F%E3%80%82%E5%9C%A8%E6%9C%AC%E4%B9%A6%E7%9A%84%E7%AC%AC8%E3%80%819%E7%AB%A0%E4%BB%8B%E7%BB%8D%E4%BA%86Microsoft%20SQL%20Server%202000%E6%95%B0%E6%8D%AE%E5%BA%93%E7%AE%A1%E7%90%86%E7%B3%BB%E7%BB%9F%EF%BC%8C%E5%B1%8A%E6%97%B6%E5%90%8C%E5%AD%A6%E4%BB%AC%E4%B8%80%E5%AE%9A%E8%A6%81%E7%BB%93%E5%90%88%E8%AF%95%E9%AA%8C%E6%95%99%E6%9D%90%E8%BF%9B%E8%A1%8C%E4%B8%8A%E6%9C%BA%E8%AE%AD%E7%BB%83%EF%BC%8C%E5%B7%A9%E5%9B%BA%E5%92%8C%E6%8F%90%E9%AB%98%E5%9C%A8%E6%9C%AC%E7%AB%A0%E6%89%80%E5%AD%A6%E7%9A%84%E7%90%86%E8%AE%BA%E7%9F%A5%E8%AF%86%E3%80%82%E5%86%99%E5%87%BA%E4%B8%8B%E9%9D%A2%E7%9A%84SQL%E8%AF%AD%E5%8F%A5%E7%9A%84%E6%9F%A5%E8%AF%A2%E7%BB%93%E6%9E%9C%EF%BC%9A%0A1%20.select%20count%20%28%2A%29%3B%20from%20%E5%9B%BE%E4%B9%A6%EF%BC%9Bwhere%20%E5%8D%95%E4%BB%B7%20between%2010%20and%2025%20%0A2.select%20MAX%28%E5%8D%95%E4%BB%B7%EF%BC%89as%20%E6%9C%80%E9%AB%98%E4%BB%B7%20MIN%28%E5%8D%95%E4%BB%B7%29%20as%20%E6%9C%80%E4%BD%8E%E4%BB%B7%20%2CAVG%28%E5%8D%95%E4%BB%B7%29%20as%20%E5%B9%B3%E5%9D%87%E4%BB%B7%EF%BC%9Bfrom%20%E5%9B%BE%E4%B9%A6%0A3.select%20%E5%80%9F%E4%B9%A6%E8%AF%81%E5%8F%B7%EF%BC%8Ccount%28%2A%29%3Bfrom%20%E5%80%9F%E9%98%85%EF%BC%9Bwhere%20%E5%80%9F%E4%B9%A6%E6%97%A5%E6%9C%9F%3C%7B99/01/01%7D%3B%20group%20by%20%E5%80%9F%E4%B9%A6%E8%AF%81%E5%8F%B7%3Bhaving%20count%28%2A%29%3E%3D3%0A

招生简章

迎新生的欢迎词

职教云旧版本