Search
โœ…

2๏ธโƒฃ ๋‹ต ๋ณด๊ธฐ

SELECT ๊ณผ๋ชฉ์ด๋ฆ„ , MIN(์ ์ˆ˜) AS ์ตœ์†Œ์ ์ˆ˜ , MAX(์ ์ˆ˜) AS ์ตœ๋Œ€์ ์ˆ˜ FROM ์„ฑ์  GROUP BY ๊ณผ๋ชฉ์ด๋ฆ„ HAVING AVG(์ ์ˆ˜) >= 90;
SQL
๋ณต์‚ฌ