TIL 20240926

🖥️ 1.Today I Learned

-알고리즘,SQL 문제 풀기

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

SELECT P.PRODUCT_ID,P.PRODUCT_NAME, SUM(O.AMOUNT *P.PRICE) AS TOTAL_SALES 
FROM FOOD_PRODUCT P 
JOIN FOOD_ORDER O ON P.PRODUCT_ID = O.PRODUCT_ID
WHERE DATE_FORMAT(O.PRODUCE_DATE, '%Y-%m') = '2022-05'
GROUP BY P.PRODUCT_ID,P.PRODUCT_NAME
ORDER BY TOTAL_SALES DESC, PRODUCT_ID ASC;

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

def solution(cards1, cards2, goal):
    idx1,idx2=0,0
    
    for i in goal:
        if idx1 < len(cards1) and i == cards1[idx1]:
            idx1 = idx1+1
        
        elif idx2 < len(cards2) and i == cards2[idx2]:
            idx2 = idx2+1
        else :
            return "No"
        
    return "Yes"