๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
728x90
๋ฐ˜์‘ํ˜•

์•Œ๊ณ ๋ฆฌ์ฆ˜ ๐Ÿ’ก47

[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ๊ฐ€๊ฒฉ์ด ์ œ์ผ ๋น„์‹ผ ์‹ํ’ˆ์˜ ์ •๋ณด ์ถœ๋ ฅํ•˜๊ธฐ _ SQL https://school.programmers.co.kr/learn/courses/30/lessons/131115 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”.programmers.co.kr  SELECT *FROM FOOD_PRODUCTWHERE price = (SELECT MAX(price) FROM FOOD_PRODUCT) 1. ์„œ๋ธŒ ์ฟผ๋ฆฌ  SELECT MAX(PRICE) FROM FOOD_PRODUCT ๋Š” FOOD_PRODUCT ํ…Œ์ด๋ธ”์—์„œ ๊ฐ€์žฅ ๋†’์€ ๊ฐ€๊ฒฉ์„ ์ฐพ์Šต๋‹ˆ๋‹ค.2. ๋ฉ”์ธ ์ฟผ๋ฆฌ๋Š” ์„œ๋ธŒ ์ฟผ๋ฆฌ์—์„œ ๋ฐ˜ํ™˜๋œ ๊ฐ€์žฅ ๋†’์€ ๊ฐ€๊ฒฉ๊ณผ ๋™์ผํ•œ ๊ฐ€๊ฒฉ์„ ๊ฐ€์ง„ ์‹ํ’ˆ์˜ ์ •๋ณด๋ฅผ .. 2024. 6. 16.
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์„ธ๊ท  ์ฆ์‹_ํŒŒ์ด์ฌ ํ’€์ด https://school.programmers.co.kr/learn/courses/30/lessons/120910 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”.programmers.co.kr def solution(n, t): return n * (2 ** t)# ์˜ˆ์ œ ์‚ฌ์šฉprint(solution(2, 10)) # ๊ฒฐ๊ณผ: 2048print(solution(7, 15)) # ๊ฒฐ๊ณผ: 229376 2024. 6. 13.
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์ค‘๋ณต๋œ ์ˆซ์ž ๊ฐœ์ˆ˜_ํŒŒ์ด์ฌ ํ’€์ด https://school.programmers.co.kr/learn/courses/30/lessons/120583 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”.programmers.co.kr  def solution(array, n): n_count = 0 for i in array: # print(i) if (i == n): n_count += 1 # print(n_count) return n_count# ์˜ˆ์ œ ์‚ฌ์šฉprint(solution([1, 1, 2, 3, 4, 5], 1)) # ๊ฒฐ๊ณผ: 2print(solut.. 2024. 6. 13.
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] ์ „ํ™”๋ฒˆํ˜ธ ๋ชฉ๋ก_ํŒŒ์ด์ฌ ํ’€์ด https://school.programmers.co.kr/learn/courses/30/lessons/42577 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”.programmers.co.kr def solution(phone_book): # ์ „ํ™”๋ฒˆํ˜ธ๋ฅผ ์ •๋ ฌํ•ฉ๋‹ˆ๋‹ค. phone_book.sort() # ์ธ์ ‘ํ•œ ๋‘ ๋ฒˆํ˜ธ๋ฅผ ๋น„๊ตํ•ฉ๋‹ˆ๋‹ค. for i in range(len(phone_book)-1): if phone_book[i + 1].startswith(phone_book[i]): return False return True 2024. 6. 12.
728x90
๋ฐ˜์‘ํ˜•