TIL(Today I Learned) 69일차(24.02.16)

SQL & Python 예제

SQL

596. Classes More Than 5 Students

https://leetcode.com/problems/classes-more-than-5-students/description/

SELECT CLASS
FROM   
(
SELECT COUNT(STUDENT) STU_CNT,
       CLASS
FROM COURSES
GROUP BY CLASS    
) A
WHERE STU_CNT >= 5

 

1729. Find Followers Count

https://leetcode.com/problems/find-followers-count/description/

SELECT USER_ID, COUNT(FOLLOWER_ID) FOLLOWERS_COUNT
FROM FOLLOWERS
GROUP BY USER_ID
ORDER BY USER_ID

 

Python

문자열 내림차순으로 배치하기

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

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

 

부족한 금액 계산하기

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

def solution(price, money, count):
    answer = 0
    for i in range(1, count+1):
        val = price * i
        answer+=val
    if money >= answer:
        return 0
    else:
        answer2 = abs(money-answer)
        return answer2

 

심화 프로젝트

2024.02.16 - [데이터 분석 공부/프로젝트] - 심화 프로젝트 11일차(24.02.16)

심화 프로젝트 11일차(24.02.16)