TIL(Today I Learned) 72일차(24.02.19)

심화 프로젝트

2024.02.19 - [데이터 분석 공부/프로젝트] - 심화 프로젝트 14일차(24.02.19)(feat. 다른 팀의 피드백으로부터 배운 점)

심화 프로젝트 14일차(24.02.19)(feat. 다른 팀의 피드백으로부터 배운 점)

 

SQL & PYTHON 예제 풀기

SQL

1045. Customers Who Bought All Products

https://leetcode.com/problems/customers-who-bought-all-products/description/

SELECT CUSTOMER_ID
FROM CUSTOMER
GROUP BY CUSTOMER_ID
HAVING COUNT(DISTINCT PRODUCT_KEY) = (SELECT COUNT(*) FROM PRODUCT)

 

1731. The Number of Employees Which Report to Each Employee

https://leetcode.com/problems/the-number-of-employees-which-report-to-each-employee/description/

WITH FIRST AS(
SELECT REPORTS_TO, COUNT(REPORTS_TO) REPORTS_COUNT, ROUND(AVG(AGE)) AVERAGE_AGE
FROM EMPLOYEES
GROUP BY REPORTS_TO
HAVING COUNT(REPORTS_TO) >= 1
)
SELECT EM.EMPLOYEE_ID,
       EM.NAME,
       FI.REPORTS_COUNT,
       FI.AVERAGE_AGE
FROM EMPLOYEES EM LEFT JOIN FIRST FI ON EM.EMPLOYEE_ID = FI.REPORTS_TO
WHERE FI.REPORTS_TO IS NOT NULL
ORDER BY EM.EMPLOYEE_ID

 

PYTHON

문자열 다루기 기본

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

def solution(s):
    val = list(s)
    count = 0
    if len(val) == 4:
        for i in range(10):
            for j in val:
                if str(i) == j:
                    count+=1
                else:
                    count+=0
    elif len(val) == 6:
        for i in range(10):
            for j in val:
                if str(i) == j:
                    count+=1
                else:
                    count+=0
    else:
        return False                
    if count == len(val):
        return True
    else:
        return False