TIL 20240909

🖥️ 1.오늘 한 일

-계산기 프로젝트 하기

-알고리즘,SQL 문제 풀기

https://school.programmers.co.kr/learn/courses/30/lessons/12903

def solution(s):
    answer = ''
    length = len(s)
    if length % 2 == 0:
        answer = s[(length // 2) - 1:(length // 2) + 1]

    else:
        answer = s[length // 2]
    
    return answer

https://school.programmers.co.kr/learn/courses/30/lessons/12922

def solution(n):
    answer = ''
    if n % 2 == 0: 
        answer = "수박" * (n // 2)
    else:  
        answer = "수박" * (n // 2) + "수"
        
    return answer

https://school.programmers.co.kr/learn/courses/30/lessons/70128

def solution(a, b):
    answer =0
    for i in range(len(b)):
        answer += a[i] * b[i]
    return answer

https://school.programmers.co.kr/learn/courses/30/lessons/132201

SELECT PT_NAME,PT_NO,GEND_CD,AGE,
       COALESCE(TLNO, 'NONE') AS TLNO
FROM PATIENT 
WHERE AGE <= 12 AND GEND_CD = 'W' 
ORDER BY AGE DESC, PT_NAME ASC;

https://school.programmers.co.kr/learn/courses/30/lessons/133024

SELECT FLAVOR
FROM FIRST_HALF 
ORDER BY TOTAL_ORDER DESC, SHIPMENT_ID;

https://school.programmers.co.kr/learn/courses/30/lessons/151137

SELECT CAR_TYPE, COUNT(CAR_ID) AS "CARS" FROM CAR_RENTAL_COMPANY_CAR 
WHERE OPTIONS like '%통풍시트%' or 
OPTIONS like '%열선시트%' or  OPTIONS like '%가죽시트%'
GROUP BY CAR_TYPE
ORDER BY  CAR_TYPE ASC