TIL - 코드카타

알고리즘

 

def solution(k, m, score):

    score.sort(reverse=True)
    
    max_profit = 0 
    
    for i in range(0, len(score) - m + 1, m):
        min_score = score[i + m - 1]  
        max_profit += min_score * m  
    
    return max_profit

 

 

SQL

 

SELECT 
    B.CATEGORY, 
    SUM(BS.SALES) AS TOTAL_SALES
FROM BOOK B
JOIN BOOK_SALES BS ON B.BOOK_ID = BS.BOOK_ID
WHERE BS.SALES_DATE BETWEEN '2022-01-01' AND '2022-01-31'
GROUP BY B.CATEGORY
ORDER BY B.CATEGORY;