Banner

My Tech Blog (ํ•ด๋‹ต)

์˜ค๋Š˜์˜ ๋ช…์–ธ
" ๋‹น์‹ ์ด ์„ธ์ƒ์—์„œ ๋ณด๊ณ  ์‹ถ์€ ๋ณ€ํ™”๊ฐ€ ๋˜์„ธ์š”. "
- ๊ฐ„๋”” (์ธ๋„ ๋…๋ฆฝ์šด๋™๊ฐ€, ์ •์น˜ ์ง€๋„์ž)
๐Ÿ“‘ 1. ๋ฌธ์ œ์„ค๋ช… ๐Ÿ’ก 2. ํ’€์ด๊ณผ์ •๋‘ ๊ฐ€์ง€ ๊ฒฝ์šฐ๋กœ ๋‚˜๋ˆ„์–ด์„œ ํ•ด๊ฒฐํ•˜๊ธฐdirection ์ด right์ธ ๊ฒฝ์šฐ์™€ left์ธ ๊ฒฝ์šฐ๋กœ ๊ตฌ๋ถ„ํ–ˆ๋‹ค."right" ๋ฐฉํ–ฅ์œผ๋กœ ํšŒ์ „: ๋ฐฐ์—ด์˜ ๋งˆ์ง€๋ง‰ ์š”์†Œ๋ฅผ ๋งจ ์•ž์— ๋„ฃ๊ธฐ + ๋‚˜๋จธ์ง€ ์š”์†Œ๋“ค์€ ํ•œ ์นธ์”ฉ ๋’ค๋กœ ์ด๋™"left" ๋ฐฉํ–ฅ์œผ๋กœ ํšŒ์ „: ๋ฐฐ์—ด์˜ ์ฒซ ๋ฒˆ์งธ ์š”์†Œ๋ฅผ ๋งจ ๋’ค๋กœ ๋ณด๋‚ด๊ธฐ + ๋‚˜๋จธ์ง€ ์š”์†Œ๋“ค์€ ํ•œ ์นธ์”ฉ ์•ž์ชฝ์œผ๋กœ ์ด๋™๐Ÿ‘จโ€๐Ÿ’ป 3. ์ •๋‹ต์ฝ”๋“œ๋‚ด๊ฐ€ ํ‘ผ ์ฝ”๋“œimport java.util.*;class Solution { public int[] solution(int[] numbers, String direction) { int[] answer = new int[numbers.length]; if (direction.equals("right")) {..
๐Ÿ“‘ 1. ๋ฌธ์ œ์„ค๋ช… ์ž…์ถœ๋ ฅ ์˜ˆletterresult".... . .-.. .-.. ---""hello" ".--. -.-- - .... --- -.""python" ๐Ÿ’ก 2. ์ ‘๊ทผ๋ฐฉ์‹์ฃผ์–ด์ง„ ๋ชจ์Šค๋ถ€ํ˜ธ๋ฅผ morse.put() ์œผ๋กœ ํ•œ ์ค„์”ฉ ํ•ด์‹œ๋งต์— ์ถ”๊ฐ€ ํ•ด์•ผ ํ•œ๋‹ค๋Š” ๋ถ€๋ถ„์ด ๊ท€์ฐฎ์€ ๋ฌธ์ œ์ด๋‹ค. 1. HashMap์„ ์ด์šฉํ•ด ๋ชจ์Šค๋ถ€ํ˜ธ์™€ ์•ŒํŒŒ๋ฒณ์„ ํ‚ค,๊ฐ’ ์Œ์œผ๋กœ ์ €์žฅํ•˜๊ธฐ2. split() ๋ฉ”์„œ๋“œ๋กœ ๋ฌธ์ž์—ด์„ ๊ณต๋ฐฑ ๊ธฐ์ค€์œผ๋กœ ๋‚˜๋ˆ„๊ธฐ3. StringBuilder๋กœ ๋ฌธ์ž์—ด์„ ์กฐํ•ฉํ•ด์„œ ๋ฐ˜ํ™˜โญ 3. ์ •๋‹ต์ฝ”๋“œimport java.util.*; class Solution { public String solution(String letter) { Map morse = new HashMap(); // ..
๐Ÿ“‘ 1. ๋ฌธ์ œ์„ค๋ช…๐Ÿ’ก 2. ์ ‘๊ทผ๋ฐฉ์‹WHERE์ ˆ์ด๋ž‘ HAVING ์ ˆ ์“ฐ์ž„์ด ๋„ˆ๋ฌด๋„ˆ๋ฌด ํ—ท๊ฐˆ๋ฆฐ๋‹ค.  ์™œ HAVING์„ ์‚ฌ์šฉํ•˜๋Š”๊ฐ€? ์ด ๋ฌธ์ œ์—์„œ๋Š” ํ‰๊ท  ๋Œ€์—ฌ ๊ธฐ๊ฐ„(AVG)์„ ๊ณ„์‚ฐํ•œ ํ›„ ํ•ด๋‹น ๊ฐ’์ด 7 ์ด์ƒ์ธ ๊ทธ๋ฃน๋งŒ ํ•„ํ„ฐ๋งํ•ด์•ผ ํ•œ๋‹ค.ํ‰๊ท ์„ ๊ณ„์‚ฐํ•˜๋ ค๋ฉด ๋จผ์ € CAR_ID ๋ณ„๋กœ ๊ทธ๋ฃนํ™”๋ฅผ ํ•ด์•ผํ•œ๋‹ค.์ดํ›„์— ์กฐ๊ฑด์„ ์ ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ์ ˆ์ด ๋ฐ”๋กœ HAVING์ด๋‹ค.์ฆ‰, WHERE ์ ˆ๋กœ๋Š” ๊ทธ๋ฃนํ™” ์ดํ›„์˜ ์ง‘๊ณ„ ๊ฒฐ๊ณผ๋ฅผ ํ•„ํ„ฐ๋งํ•  ์ˆ˜ ์—†๊ธฐ ๋•Œ๋ฌธ์— ๋ฐ˜๋“œ์‹œ HAVING์„ ์‚ฌ์šฉํ•ด์•ผ ํ•œ๋‹ค. ์–ธ์ œ WHERE์ ˆ์„ ์จ์•ผ ํ•˜๊ณ , ์–ธ์ œ HAVING ์ ˆ์„ ์จ์•ผ ํ•˜๋Š”์ง€ ์ •๋ง ํ—ท๊ฐˆ๋ฆฐ๋‹ค.์ด๊ฑด SQL ์ฟผ๋ฆฌ๋ฌธ ์‹คํ–‰ ์ˆœ์„œ์™€ ๊ด€๋ จ์ด ์žˆ๋‹ค.FROM - WHERE - GROUP BY - HAVING - SELECT - ORDER BYHAVING์€ GROUP BY ์ดํ›„ ์‹คํ–‰..
์ƒ๋‹จ์œผ๋กœ