TIL(Today I Learned) 68일차(24.02.15)

심화 프로젝트

2024.02.15 - [데이터 분석 공부/프로젝트] - 심화 프로젝트 10일차(24.02.15)

심화 프로젝트 10일차(24.02.15)

 

SQLD(3주차-식별자)

 

SQL & PYTHON 예제

SQL

596. Classes More Than 5 Students

https://leetcode.com/problems/product-sales-analysis-iii/description/

SELECT PRODUCT_ID, YEAR FIRST_YEAR, QUANTITY, PRICE
FROM
(
SELECT RANK() OVER(PARTITION BY PRODUCT_ID ORDER BY YEAR) RANKING,
       SALE_ID, PRODUCT_ID, YEAR, QUANTITY, PRICE
FROM SALES
) FIRST
WHERE RANKING = 1

 

PYTHON

수박수박수박수박수박수?

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

def solution(n):
    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(a)):
        val = a[i] * b[i]
        answer+=val
    return answer

 

약수의 개수와 덧셈

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

def solution(left, right):
    answer = 0
    answer2 = 0
    for i in range(left, right+1):
        for j in range(1, i+1):
            if i % j == 0:
                answer+=1
            else:
                answer+=0    
        if answer % 2 == 0:
            answer2+=i
            answer = 0
        else:
            answer2-=i
            answer = 0
    return answer2