Community

๐ŸงSQL ์ง‘๊ณ„ํ•จ์ˆ˜ ๋ฌธ์ œ๋ฅผ ๊ฐ™์ด ํ’€์–ด๋ด์š”๐Ÿง ์ €๋ฒˆ ์ง‘๊ณ„ํ•จ์ˆ˜ ๊ฐ•์˜๋Š” ์–ด๋– ์…จ๋‚˜์š”? ์ด๋ก ์€ ๊ฐ„๋‹จํ•ด๋ณด์—ฌ๋„ ์‹ค์ œ๋กœ ์ ์šฉํ•  ๋•Œ๋Š” ์–ด๋ ต๊ฒŒ ๋А๊ปด์ง€๋Š” ๋‚ด์šฉ์ธ๋ฐ์š”, ๋ฌธ์ œ ํ’€์ด๋ฅผ ํ•˜๋ฉด์„œ ๋‚ด์šฉ์„ ํ™•์‹คํžˆ ์ดํ•ดํ•˜๋Š” ์‹œ๊ฐ„์„

๐ŸงSQL ์ง‘๊ณ„ํ•จ์ˆ˜ ๋ฌธ์ œ๋ฅผ ๊ฐ™์ด ํ’€์–ด๋ด์š”๐Ÿง ์ €๋ฒˆ ์ง‘๊ณ„ํ•จ์ˆ˜ ๊ฐ•์˜๋Š” ์–ด๋– ์…จ๋‚˜์š”? ์ด๋ก ์€ ๊ฐ„๋‹จํ•ด๋ณด์—ฌ๋„ ์‹ค์ œ๋กœ ์ ์šฉํ•  ๋•Œ๋Š” ์–ด๋ ต๊ฒŒ ๋А๊ปด์ง€๋Š” ๋‚ด์šฉ์ธ๋ฐ์š”, ๋ฌธ์ œ ํ’€์ด๋ฅผ ํ•˜๋ฉด์„œ ๋‚ด์šฉ์„ ํ™•์‹คํžˆ ์ดํ•ดํ•˜๋Š” ์‹œ๊ฐ„์„ ๊ฐ€์ ธ๋ด…์‹œ๋‹ค! ํ˜น์‹œ ์•„์ง ์ด๋ก  ๊ฐ•์˜๋ฅผ ์•ˆ๋ณด์…จ๋‹ค๋ฉด ์ด์ „ ๊ฒŒ์‹œ๊ธ€์„ ํ™•์ธํ•ด์ฃผ์„ธ์š”! ๊ฐ•์˜๋ฅผ ๋ณด๊ธฐ ์ „, ์˜์ƒ ์ดˆ๋ฐ˜์— ์†Œ๊ฐœ๋˜๋Š” ๋ฌธ์ œ 6๊ฐœ๋ฅผ HackerRank์—์„œ ๋จผ์ € ํ’€์–ด๋ณด์‹œ๋ฉด ์ข‹์Šต๋‹ˆ๋‹ค :) 1. Revising Aggregations - Averages 2. Revising Aggregations - The Sum Function 3. Revising Aggregations - The Count Function 4. Average Population 5. Population Density Difference 6. Weather Observation Station 4 ๊ทธ๋Ÿผ SQL ๋ฌธ์ œ ํ’€๋Ÿฌ ๊ฐ€๋ด…์‹œ๋‹ค! ์งˆ๋ฌธ์ด ์žˆ์œผ์‹œ๋‹ค๋ฉด ์˜์ƒ ๋Œ“๊ธ€๋กœ ๋‚จ๊ฒจ์ฃผ์„ธ์š” :)

์•Œ๋ฆผ

์•Œ๋ฆผ์ด ์—†์Šต๋‹ˆ๋‹ค