TIL 20240910

🖥️ 1.오늘 한 일

- 계산기 프로젝트

README.md 파일 작성하고 과제 제출

-알고리즘,SQL 문제 풀기

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

SELECT i.NAME,i.DATETIME
FROM ANIMAL_INS i
LEFT JOIN ANIMAL_OUTS o ON i.ANIMAL_ID = o.ANIMAL_ID
WHERE o.ANIMAL_ID IS NULL
ORDER BY i.DATETIME
LIMIT 3;

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

SELECT category,sum(sales) as total_sales
from book_sales  s
left join book b on s.book_id = b.book_id
WHERE s.SALES_DATE >= '2022-01-01' AND s.SALES_DATE < '2022-02-01'
group by category
order by category asc

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

def solution(left, right):
    answer = 0 
    for i in range(left, right + 1):
        if int(i ** 0.5) == i ** 0.5:
            answer -= i
        else:
            answer += i
    return answer

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

    def solution(s):
    answer = ''
    answer = ''.join(sorted(s, reverse=True))
    return answer