![](http://i1.daumcdn.net/thumb/C148x148/?fname=https://blog.kakaocdn.net/dn/cdT0bf/btsGNdqrejc/bNn3VfUk2yuzRBXSLZWn4k/img.png)
1. stable diffusion์ dreambooth๋ก ํ์ธํ๋ ์ค train์์ ์๋ฌ๊ฐ ๊ณ์ ๋ฐ์ํ๋ค.2. ์ฒ์์ GPU๋ฅผ A100์ผ๋ก ๋๋ ค์, T4๋ก ๋ฐ๊ฟ์ฃผ๋๊น ํด๊ฒฐ์ด ๋๋๋ฐ ๊ทธ ๋ค์ ํ์ต๋ถํฐ๋ T4์์๋ ๊ณ์ ๊ฐ์ ์๋ฌ ๋ฐ์.3. ํด๊ฒฐํ๋ ค๊ณ ๋ณ ์ง์ ๋คํ๋๋ฐ ์๋ผ์ ๊ณจ๋จธ๋ฆฌ๋ฅผ ์๋ ์ค!4. ๋ค์ ์ฝ๋๋ก ํด๊ฒฐ !pip install "jax[cuda12_local]==0.4.23" -f https://storage.googleapis.com/jax-releases/jax_cuda_releases.html!pip install diffusers==0.11.1!pip install transformers scipy ftfy accelerate train ์ ์ ์ด๊ฑธ ๋๋ ค์ฃผ๊ณ ,train ์ํค๋ฉด ํ์ต์ด ์..
stable diffusion ๋ชจ๋ธ์ ์ฝ๋ฉ์์ loadํ ๋, peft๊ด๋ จ ์๋ฌ๊ฐ ๋๋ ๊ฒฝ์ฐ !pip install peft %reset ๋ฅผ ํด์ฃผ๋ฉด pipe.to('cuda') ์ ์ค์ ์ฝ์ ๋ ์ค๋ฅ๊ฐ ์ฌ๋ผ์ง๋ค. ๊ทธ๋ผ์ด๋ง . .
![](http://i1.daumcdn.net/thumb/C148x148/?fname=https://blog.kakaocdn.net/dn/b8aqOi/btsFgLWh63g/6KGd3wfUKpuZqeeAqMaPbK/img.png)
๋ฌธ์ : ์ฝ๋: -- ์ฝ๋๋ฅผ ์์ฑํด์ฃผ์ธ์ 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์ ์ ์กฐ๊ฑด ์จ์ฃผ๊ธฐ
![](http://i1.daumcdn.net/thumb/C148x148/?fname=https://blog.kakaocdn.net/dn/54P7a/btsEZbVKp2g/OkkeFrtKGXWYwSUAOKQ8Y1/img.png)
๋ฌธ์ : ์ฝ๋: 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 ํ์ฉ! ***
![](http://i1.daumcdn.net/thumb/C148x148/?fname=https://blog.kakaocdn.net/dn/oDQiE/btsEIN7UdJh/fLG3Mb9T6YZVG1gsD79B2k/img.png)
๋ฌธ์ : ์ฝ๋: -- ์ฝ๋๋ฅผ ์ ๋ ฅํ์ธ์ 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 ์ค๊ฐ์ ์ฌ์ฉ!
![](http://i1.daumcdn.net/thumb/C148x148/?fname=https://blog.kakaocdn.net/dn/dWTLFO/btsEFSbcQEr/arVN4oXOxsraF0QTzfk0CK/img.png)
๋ฌธ์ : ์ฝ๋: 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์ด ํฌํจ๋์ด ์๋ ์ด๋ฆ ์ถ๋ ฅ
- Total
- Today
- Yesterday
- ์คํ ์ด๋ธ๋ํจ์
- gan
- ์ฝ๋ฉ์๋ฌ
- ๋๋ฆผ๋ถ์ค
- ์ฝํ ์ค๋น
- ํ๋ก๊ทธ๋๋จธ์ค
- ๋ ผ๋ฌธ์ฝ๊ธฐ
- ํ์ด์ฌ
- ์ฝ๋ฉ๊ณต๋ถ
- lgaimers
- ์ฝํ
- dreambooth
- ๊ตฌ๊ธ์ฝ๋ฉ
- AIRUSH2023
- MYSQL
- AI์ปจํผ๋ฐ์ค
- SQL
- CLOVAX
- ํ ํฌ์๋ฐ
- Aimers
- C์ธ์ด
- AIRUSH
- ๋ ผ๋ฌธ๋ฆฌ๋ทฐ
- HyperCLOVA
- SKTECHSUMMIT
- ๊ธฐ์ ์ปจํผ๋ฐ์ค
- DALLE
- WGAN
- ํ์ด์ฌ์ฝํ
- StableDiffusion
์ผ | ์ | ํ | ์ | ๋ชฉ | ๊ธ | ํ |
---|---|---|---|---|---|---|
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 |