๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

728x90
๋ฐ˜์‘ํ˜•

๐Ÿ“ ์•Œ๊ณ ๋ฆฌ์ฆ˜

(165)
[MySQL/PGS] Lv.4 : 5์›” ์‹ํ’ˆ๋“ค์˜ ์ด๋งค์ถœ ์กฐํšŒํ•˜๊ธฐ https://school.programmers.co.kr/learn/courses/30/lessons/131117 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.krํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ 4, SQL ์ฟผ๋ฆฌ ๋ฌธ์ œ.join, like ์‚ฌ์šฉํ•ด์„œ ํ’€์—ˆ๋‹ค๋ฌธ์ž์—ด์ด ์•„๋‹ˆ๋ผ ๋‚ ์งœ๋ผ์„œ ๋‹ค๋ฅธ ํ’€์ด ๋ฐฉ๋ฒ•๋„ ๋งŽ์ด ์žˆ์„๋“ฏ! ๋‚˜์˜ ํ’€์ดselect P.PRODUCT_ID, P.PRODUCT_NAME, sum(O.AMOUNT*P.PRICE) as TOTAL_SALESfrom FOOD_PRODUCT P, FOOD_ORDER Owhere P.PRODUCT_ID = O.PRODUCT_ID and O.PRODUCE_DATE like '2022-0..
[Javascript/PGS] Lv.2 : ๋ฐฉ๋ฌธ ๊ธธ์ด (Set) https://school.programmers.co.kr/learn/courses/30/lessons/49994?language=javascript ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.krํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ2.set ์ž๋ฃŒํ˜•์„ ํ™œ์šฉํ•˜๋ฉด ๊ฐ„๋‹จํ•˜๊ฒŒ ํ•ด๊ฒฐํ•  ์ˆ˜ ์žˆ๋‹ค.๋ฌธ์ œ๋Š”.. ๊ฐ์ฒด(๋ฐฐ์—ด ํฌํ•จ)๋Š” ์ฐธ์กฐ(reference)๋กœ ๋น„๊ตํ•˜๊ธฐ ๋•Œ๋ฌธ์— ๊ฐ™์€ ๊ฐ’์„ ๊ฐ€์ง„ ๋ฐฐ์—ด์ด ์—ฌ๋Ÿฌ ๊ฐœ ๋“ค์–ด๊ฐˆ ์ˆ˜ ์žˆ๋‹ค์˜๋„๋Œ€๋กœ ๋ฐฐ์—ด์„ Set์— ๋„ฃ์–ด์„œ ์“ฐ๋ ค๋ฉด ๋ฌธ์ž์—ด๋กœ ๋ฐ”๊ฟ”์•ผ ํ•จ ใ…Žใ…Ž ๋‹ค๋ฅธ ์–ธ์–ด๋„ ๊ทธ๋Ÿฐ๊ฐ€ ์‹ถ์–ด์„œ C++, ํŒŒ์ด์ฌ๋„ gptํ•œํ…Œ ๋ฌผ์–ด๋ดค๋‹ค๐Ÿš€ ์ •๋ฆฌ: ์–ธ์–ด๋ณ„ Set์—์„œ ๋ฐฐ์—ด(๊ฐ์ฒด)์˜ ์ค‘๋ณต ๋น„๊ต ๋ฐฉ์‹์–ธ์–ด๊ธฐ๋ณธ ์ž๋ฃŒํ˜• (int, string..
[Javascript/PGS] Lv.3 : ์Šคํ‹ฐ์ปค ๋ชจ์œผ๊ธฐ(2) - ํ•˜๋‚˜๋งŒ ํ‹€๋ฆด ๋•Œ ํ•ด๊ฒฐ https://school.programmers.co.kr/learn/courses/30/lessons/12971 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.krํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ 3.๋†“์น˜๊ธฐ ์‰ฌ์šด ๋ถ€๋ถ„์„ ๋‹ค์‹œ ์ƒ๊ธฐ์‹œ์ผœ์ฃผ๋Š” ๋ฌธ์ œ์ „๋ฐ˜์ ์ธ ๊ณผ์ •์€ Dynamic Programming์œผ๋กœ ํ•ด๊ฒฐ์ด ๊ฐ€๋Šฅํ•˜๋‹ค. 1. DP - ์ œ์ถœ ์‹œ 85.9์ ์ •ํ™•์„ฑ 1๊ฐœ(ํ…Œ์ŠคํŠธ 33๋ฒˆ), ํšจ์œจ์„ฑ 1๊ฐœ(1๋ฒˆ) ํ‹€๋ฆผ์ด์œ ๋Š” .. N์ด 1์ธ ๊ฒฝ์šฐ๋ฅผ ์˜ˆ์™ธ์ฒ˜๋ฆฌํ•ด์ค˜์•ผ ํ–ˆ๋‹ค.ํ‘ํ‘ ๊ฒฝ๊ณ„๊ฐ’ ํ…Œ์ŠคํŠธ ์ž˜ ํ•ด๋ณด์ž ๊ธธ์ด๊ฐ€ 1์ผ ๋•Œ๋Š” ๋ฐ”๋กœ ๋ฆฌํ„ดํ•˜๋„๋ก ํ•ด์คฌ๋”๋‹ˆ, 100์  ํ†ต๊ณผ!  2. ์ œ์ถœ ์‹œ 100์ ๐Ÿ˜Ž๋‚˜์˜ ํ’€์ดfunction solution(sticker) {..
[Javascript/PGS] Lv.3 : ๋“ฑ๋Œ€ - js ๋Ÿฐํƒ€์ž„์—๋Ÿฌ ํ•ด๊ฒฐ๋ฒ• https://school.programmers.co.kr/learn/courses/30/lessons/133500 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ 3 ๋“ฑ๋Œ€ ๋ฌธ์ œ - ํŠธ๋ฆฌ dp, dfs ์œ ํ˜•* ์ •๋‹ต ํ’€์ด๋Š” ์ตœํ•˜๋‹จ์— 1. ์žฌ๊ท€ ํ’€์ด - DFS์ด ํ’€์ด๋Š” ํŠธ๋ฆฌ dp ๋ฌธ์ œ์˜ ์ •์„์ธ ๋Š๋‚Œ์ธ๋ฐ, js๋กœ๋Š” ํ’€ ์ˆ˜ ์—†๋‹ค.ํŒŒ์ด์ฌ์˜ ๊ฒฝ์šฐ์—๋Š” sys.setrecursionlimit๋ฅผ ์‚ฌ์šฉํ•œ๋‹ค๋ฉด, ์žฌ๊ท€์˜ ์ตœ๋Œ€ ๊นŠ์ด๋ฅผ ์„ค์ •ํ•  ์ˆ˜ ์žˆ์–ด์„œ์ด๋ ‡๊ฒŒ ํ’€๋ฉด ๋˜์ง€๋งŒ...์ž์Šค๋Š” ๊ทธ๋Ÿฐ๊ฑฐ ์—†๋‹ค๊ณ  ํ•จ ์ด ํ’€์ด๋กœ ์ œ์ถœ ์‹œ 93.8์ ์ด ๋‚˜์™”๋‹ค. (ํ…Œ์ŠคํŠธ 9๋งŒ ํ‹€๋ฆผ) let dp = null;let visited = ..
[Javascript/PGS] Lv.2 : ์Šคํ‚ฌํŠธ๋ฆฌ https://school.programmers.co.kr/learn/courses/30/lessons/49993 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ2 ๋ฌธ์ œ์™„ํƒ์œผ๋กœ ํ•ด๊ฒฐํ•จ์ตœ์•…์˜ ๊ฒฝ์šฐ(์ตœ๋Œ€ ์ž…๋ ฅ)์—๋„ 20 * 26 * 26 ์ด๊ธฐ ๋•Œ๋ฌธ์—.. ์‚ผ์ค‘๋ฐ˜๋ณต๋ฌธ ์™„์ „ํƒ์ƒ‰์ด ๊ฐ€๋Šฅํ•˜๋‹ค! ๋‚˜์˜ ํ’€์ดfunction solution(skill, skill_trees) { var answer = 0; let a = 0; let isGood = true; for(let i=0; i
[Javascript/PGS] Lv.2 : ํ”ผ๋ณด๋‚˜์น˜ ์ˆ˜ https://school.programmers.co.kr/learn/courses/30/lessons/12945 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ 2.์žฌ๊ท€๋กœ ํ’€๋ฉด ์‹œ๊ฐ„ ์ดˆ๊ณผ๋‚˜์„œ ์•ˆ๋˜๋Š” ๋“ฏ.. ๊ตณ์ด ์žฌ๊ท€๋กœ ํ’€๋ ค๊ณ  ํ•˜๋ฉด dp๋กœ ์ ํ™”์‹ ์จ์•ผ ํ•ด๊ฒฐ๋  ๊ฒƒ ๊ฐ™๋‹ค.๋‹จ์ˆœํ•˜๊ฒŒ ๋ฐ˜๋ณต๋ฌธ์œผ๋กœ ํ’€์ž!  ๋‚˜์˜ ํ’€์ดfunction solution(n) { let arr = []; let answer = 0; arr.push(0); arr.push(1); for(let i=2; i
[Javascript/PGS] Lv.3 : ๊ธฐ์ง€๊ตญ ์„ค์น˜ https://school.programmers.co.kr/learn/courses/30/lessons/12979?language=javascript# ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ 3 ๋ฌธ์ œ.์˜ˆ์ „์— c++๋กœ ํ’€๋‹ค๊ฐ€ ํ•ด๊ฒฐ ๋ชปํ–ˆ๋˜ ๋ฌธ์ œ์ธ๋ฐ, ์˜ค๋Š˜ js๋กœ๋Š” ํ•ด๊ฒฐํ–ˆ๋‹ค๊ทธ๋ž˜๋„ ์‚ฌ๊ณ ๋ ฅ์ด ์ข€ ๋Š˜์—ˆ๋‚˜..^^ ์•ฝ๊ฐ„ ์„ฑ์žฅํ•œ ๋“ฏ ํŠน๋ณ„ํ•œ ์•Œ๊ณ ๋ฆฌ์ฆ˜์„ ์“ฐ๋Š” ๋ฌธ์ œ๋Š” ์•„๋‹ˆ์ง€๋งŒ, ์‹ ๊ฒฝ์จ์•ผ ํ•  ๋ถ€๋ถ„์ด ์€๊ทผํžˆ ๋งŽ๋‹ค. ๋ฉ”์ธ ํžŒํŠธ๋Š” n์˜ ๋ฒ”์œ„์ด๋‹ค. (๋งค์šฐ ํฌ๊ธฐ ๋•Œ๋ฌธ์— stations๋ฅผ ํ™œ์šฉํ•ด์•ผ ํ•œ๋‹ค)์ฃผ์˜ํ•  ์ ์€ ์ค‘๊ฐ„์— ๋นˆ ๊ตฌ๊ฐ„ ๊ตฌํ•  ์‹œ, ์Œ์ˆ˜๋‚˜ 0์ด ๋‚˜์˜ค๋Š” ๊ฒฝ์šฐ๋ฅผ ์˜ˆ์™ธ์ฒ˜๋ฆฌํ•ด์ค˜์•ผ ํ•œ๋‹ค๋Š” ๊ฒƒ!!! ๊ทผ๋ฐ ์ œ์ถœํ•˜๋‹ˆ..
[Javascript/PGS] Lv.3 : ์•„์ดํ…œ ์ค๊ธฐ(BFS) https://school.programmers.co.kr/learn/courses/30/lessons/87694 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ๋ ˆ๋ฒจ 3 ๋ฌธ์ œ์ด๋‹ค์ฒ˜์Œ์— ์ผ๋ถ€ ํ…Œ์ผ€๊ฐ€ ๊ณ„์† ํ‹€๋ ค์„œ ์‚ฝ์งˆํ–ˆ์—ˆ๋Š”๋ฐ์•Œ๊ณ ๋ณด๋‹ˆ map ๋ณ€์ˆ˜๋ฅผ ์ฑ„์šฐ๋Š” ๊ฒŒ ๋ฌธ์ œ์˜€๋‹ค.... (์ด๊ฑฐ ํ•˜๋‚˜๋•Œ๋ฌธ์— ๋ช‡ ์‹œ๊ฐ„์„ ์•“์Œ) js์—์„œ๋Š” ๋ฐฐ์—ด ๊ฐ’์„ ์ง์ ‘ ๋ฐ”๊ฟ€๋•Œ ์ค‘๋ณต์ด ๋˜๋ฉด ๋ญ”๊ฐ€ ์˜ค๋ฅ˜๊ฐ€ ์ƒ๊ธฐ๋‚˜๋ณด๋‹ค์ค‘๋ณต, ๋ฎ์–ด์“ฐ๊ธฐ ์ตœ๋Œ€ํ•œ ์—†๋„๋ก ์งœ๊ธฐ! Main Idea => ๋งต์„ ๋‘ ๋ฐฐ๋กœ ๋Š˜๋ ค์„œ, ใ„ท์ž๋กœ ์šฐํšŒํ•ด์•ผํ•˜๋Š”๋ฐ ์งํ–‰ํ•˜๊ฒŒ ๋˜๋Š” ๋ถ€๋ถ„์ด ์—†๋„๋ก ํ•จ๊ทธ๋ฆฌ๊ณ  ์ตœ๋‹จ๊ฑฐ๋ฆฌ๋ฅผ ์ฐพ๋Š” ๋ฌธ์ œ์ด๋‹ˆ, BFS๋กœ ํ‘ผ๋‹ค!  ๋‚˜์˜ ํ’€์ดlet dx = [0, 1..

728x90
๋ฐ˜์‘ํ˜•