IM Multipotentialite

  • ํ™ˆ
  • ํƒœ๊ทธ
  • ๋ฐฉ๋ช…๋ก

ํ‰๊ท  ์ผ์ผ ๋Œ€์—ฌ ์š”๊ธˆ ๊ตฌํ•˜๊ธฐ 1

[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/SQL] Lv 1. ํ‰๊ท  ์ผ์ผ ๋Œ€์—ฌ ์š”๊ธˆ ๊ตฌํ•˜๊ธฐ (MySQL)

โญ ๋ฌธ์ œ ๋งํฌ https://school.programmers.co.kr/learn/courses/30/lessons/151136 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”. programmers.co.kr โญ ํ’€์ด ์ฝ”๋“œ SELECT ROUND(AVG(DAILY_FEE)) AS AVERAGE_FEE FROM CAR_RENTAL_COMPANY_CAR WHERE CAR_TYPE = "SUV" # ROUND(์ˆ˜์น˜๊ฐ’, ์†Œ์ˆ˜์  ์•„๋ž˜ ์ž๋ฆฌ์ˆ˜) : ๋ฐ˜์˜ฌ๋ฆผ ํ•จ์ˆ˜

SQL/Programmers 2023.04.17
์ด์ „
1
๋‹ค์Œ
๋”๋ณด๊ธฐ
ํ”„๋กœํ•„์‚ฌ์ง„

๐Ÿ— https://github.com/dorosi616

  • ์ „์ฒด ๊ธ€ (40)
    • Python (20)
      • Programmers (20)
      • Tips ! (0)
    • SQL (20)
      • Programmers (19)
      • Tips ! (1)
    • Algorithm Study (0)
    • CS Study (0)
    • AI (0)
      • Hands-On Machine Learning (0)
      • Paper Review (0)
    • Data (0)
    • ์ทจ๋ฝ€๋ฅผ ํ–ฅํ•œ ์—ฌ์ • (0)

Tag

ํƒ์š•๋ฒ•, group by, SQL, Then, AVG, Python, Programmers, ๊ทธ๋ฆฌ๋””, ์•Œ๊ณ ๋ฆฌ์ฆ˜, ํŒŒ์ด์ฌ, MySQL, ์—ฐ์Šต๋ฌธ์ œ, date_format, select, ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค, dp, ์Šคํ„ฐ๋””, ์นด์นด์˜ค, ์ฝ”ํ…Œ, ์ฝ”๋”ฉํ…Œ์ŠคํŠธ,

์ตœ๊ทผ๊ธ€๊ณผ ์ธ๊ธฐ๊ธ€

  • ์ตœ๊ทผ๊ธ€
  • ์ธ๊ธฐ๊ธ€

์ตœ๊ทผ๋Œ“๊ธ€

Archives

Calendar

ยซ   2025/07   ยป
์ผ ์›” ํ™” ์ˆ˜ ๋ชฉ ๊ธˆ ํ† 
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31

๋ฐฉ๋ฌธ์ž์ˆ˜Total

  • Today :
  • Yesterday :

Copyright ยฉ Kakao Corp. All rights reserved.

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”