๋ฌธ์ : ์ฝ๋: -- ์ฝ๋๋ฅผ ์์ฑํด์ฃผ์ธ์ SELECT DISTINCT B.ID, B.EMAIL, B.FIRST_NAME, B.LAST_NAME FROM SKILLCODES A JOIN DEVELOPERS B ON (A.CODE & B.SKILL_CODE) > 0 WHERE NAME = 'Python' OR NAME = 'C#' ORDER BY B.ID ํ์ด: 1. DISTINCT๋ก ID ์ค๋ณต ์ ๊ฑฐ๋ฅผ ํด์ค์ผ๋จ. 2. CODE๊ฐ์ด 0 ์ด์์ผ ๋
์ฝ๋: -- ์ฝ๋๋ฅผ ์ ๋ ฅํ์ธ์ SELECT A.REST_ID, A.REST_NAME, A.FOOD_TYPE, A.FAVORITES, A.ADDRESS, ROUND(AVG(B.REVIEW_SCORE), 2) AS SCORE FROM REST_INFO A JOIN REST_REVIEW B ON A.REST_ID = B.REST_ID GROUP BY REST_ID HAVING ADDRESS LIKE '์์ธ%' ORDER BY SCORE DESC,FAVORITES DESC ํ์ด: 1. ํ๊ท ๊ฐ ๊ตฌํ ๋ AVG ํจ์ ์ฐ๊ธฐ 2. ROUND(์ซ์, ์๋ฆฟ์) ์ ๋ ฅํ๋ฉด ๋ฐ์ฌ๋ฆผ๊ฐ ๊ตฌํ ์ ์์ 3. LIKE 4. GROUP BY๋ก ๋ฌถ์ ๋๋ HAVING์ ์ ์กฐ๊ฑด ์จ์ฃผ๊ธฐ
๋ฌธ์ : ์ฝ๋: def solution(numbers): try: input_list = list(map(str, numbers)) input_list.sort(key = lambda x:x*3, reverse=True) answer = '' answer = answer.join(input_list) except: print('์์ธ ๋ฐ์!') return str(int(answer)) ํ์ด: 1. list(map(str, numbers)) 2. sort ํ ๋ key ๋ก ์ ๋ ฌ ๊ธฐ์ค ์ ํ ์ ์์, lambda ์ฌ์ฉ! data_list.sort() data_list.sort(key=lambda x : len(x)) ex1) x[0]๋ฅผ ๊ธฐ์ค์ผ๋ก ์ ๋ ฌํ๊ณ ๊ฐ์ ๊ฒฝ์ฐ x[1]๋ฅผ ๊ธฐ์ค์ผ๋ก ์ ๋ ฌํ๊ธฐ arr = ['a..
์ฝ๋: def solution(brown, yellow): total = brown + yellow # a * b = total for b in range(1,total+1): if total % b == 0: # total / b = a a = total / b if a >= b: # a >= b if 2*a + 2*b == brown + 4: # 2*a + 2*b = brown + 4 return [a,b] ํ์ด: ๊ฐ๋ก๋ฅผ a, ์ธ๋ก๋ฅผ b ๋ผ๊ณ ํ๊ณ ์์ ์ธ์ฐ๊ธฐ
์ฝ๋: -- ์ฝ๋๋ฅผ ์ ๋ ฅํ์ธ์ SELECT A.PRODUCT_ID, PRODUCT_NAME, SUM(PRICE * AMOUNT) AS TOTAL_SALES FROM FOOD_PRODUCT A JOIN FOOD_ORDER B ON A.PRODUCT_ID = B.PRODUCT_ID WHERE PRODUCE_DATE LIKE '2022-05%' GROUP BY PRODUCT_ID ORDER BY TOTAL_SALES DESC, PRODUCT_ID ASC ํ์ด: 1. PRODUCT_ID๋ฅผ ํค๋ก ์กฐ์ธ 2. LIKE๋ก 5์์ธ ๊ฒ๋ค ๊ตฌํ๊ธฐ 3. GROUP BY๋ก PRODUCT_ID๋ผ๋ฆฌ ๋ฌถ์ด์ค์ผํจ!!! 4. SUM(PRICE * AMOUNT) ์ด๋งค์ถ ๊ตฌํ๊ธฐ **!
์ฝ๋: -- ์ฝ๋๋ฅผ ์ ๋ ฅํ์ธ์ SELECT BOARD_ID, WRITER_ID, TITLE, PRICE, CASE WHEN STATUS = 'DONE' THEN '๊ฑฐ๋์๋ฃ' WHEN STATUS = 'SALE' THEN 'ํ๋งค์ค' WHEN STATUS = 'RESERVED' THEN '์์ฝ์ค' END AS 'STATUS' FROM USED_GOODS_BOARD WHERE DATE_FORMAT(CREATED_DATE, '%Y-%m-%d') = '2022-10-05' ORDER BY BOARD_ID DESC ํ์ด: CASE WHEN ํ์ฉ! ***
๋ฌธ์ : ์ฝ๋: -- ์ฝ๋๋ฅผ ์ ๋ ฅํ์ธ์ SELECT ANIMAL_ID, NAME, CASE WHEN SEX_UPON_INTAKE LIKE '%Neutered%' OR SEX_UPON_INTAKE LIKE '%Spayed%' THEN 'O' ELSE 'X' END AS '์ค์ฑํ' FROM ANIMAL_INS ORDER BY ANIMAL_ID ํ์ด: CASE WHEN์ ์ฌ์ฉํ๋ฉด ๋๋ค. CASE WHEN ์กฐ๊ฑด THEN '๋ฐํ ๊ฐ' WHEN ์กฐ๊ฑด THEN '๋ฐํ ๊ฐ' ELSE 'WHEN ์กฐ๊ฑด์ ํด๋น ์๋๋ ๊ฒฝ์ฐ ๋ฐํ ๊ฐ' END SELECT ์ค๊ฐ์ ์ฌ์ฉ!
๋ฌธ์ : ์ฝ๋: SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE ANIMAL_TYPE ='DOG'AND NAME LIKE '%EL%' ORDER BY NAME ํ์ด: WHERE NAME = 'EL' ํ๋ฉด ???๊ฐ ์ด๋ฆ์ด ์ปฌ๋ผ๋ง ๋์จ๋ค. 'EL'์ด ํฌํจ๋์ด ์๋ ์ด๋ฆ์ ๊ฒ์ํ๋ ค๋ฉด LIKE๋ฅผ ์จ์ผ๋๋ค. NAME LIKE 'EL%' -> EL๋ก ์์ํ๋ ์ด๋ฆ ์ถ๋ ฅ NAME LIKE '%EL' -> EL๋ก ๋๋๋ ์ด๋ฆ ์ถ๋ ฅ NAME LIKE '%EL%' -> EL์ด ํฌํจ๋์ด ์๋ ์ด๋ฆ ์ถ๋ ฅ
๋ฌธ์ : ์ฝ๋: SELECT HOUR(DATETIME) AS HOUR, COUNT(*) AS COUNT FROM ANIMAL_OUTS WHERE HOUR(DATETIME) BETWEEN 9 AND 19 GROUP BY HOUR(DATETIME) ORDER BY HOUR(DATETIME) ASC ํ์ด: 1. DATETIME์ "2014-06-28 13:40:00" ์ด๋ฐ ํ์์ผ๋ก ๋์ด ์์. -> HOUR ํจ์๋ฅผ ์ฌ์ฉํ๋ฉด ๋จ. 2. WHERE ๋ก ๋ฒ์ ์ง์ -> BETWEEN ? AND ? ํ๋ฉด ๋จ. / where๊น์ง๋ as hour์ด ์ ์ฉ ์๋จ! 3. GROUP BY, ORDER BY ๋ as hour ์ ์ฉ๋จ.
- Total
- Today
- Yesterday
- ์ปดํจํฐ๋น์
- ๋ ผ๋ฌธ
- gs๋ ผ๋ฌธ
- Gaussian Splatting
- ์คํ ์ด๋ธ๋ํจ์
- ํ์ด์ฌ
- MYSQL
- gan
- SQL
- ๋๋ฆผ๋ถ์ค
- dreambooth
- CLOVAX
- ํ ํฌ์๋ฐ
- 2d-gs
- SKTECHSUMMIT
- ์ฝํ ์ค๋น
- 3d-gs
- ๋ ผ๋ฌธ์ฝ๊ธฐ
- ํ๋ก๊ทธ๋๋จธ์ค
- AIRUSH2023
- ๋ ผ๋ฌธ๋ฆฌ๋ทฐ
- AI์ปจํผ๋ฐ์ค
- Aimers
- AIRUSH
- ํ์ด์ฌ์ฝํ
- ์ฝ๋ฉ์๋ฌ
- Paper review
- ์ฝ๋ฉ๊ณต๋ถ
- C์ธ์ด
- lgaimers
์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
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 |