728x90 320x100 💻 하나씩 차곡차곡363 백준 1026번 파이썬 문제 링크 : https://www.acmicpc.net/problem/1026 구현N = int(input())arr1 = list(map(int, input().split()))arr2 = list(map(int, input().split()))arr1.sort()arr2.sort(reverse=True)answer = 0for i in range(N): answer += arr1[i] * arr2[i]print(answer)그리디 알고리즘을 활용하나는 오름차순 정렬, 나머지 하나는 내림차순 정렬을 하여 서로 곱하여 모두 더해주는 방식으로 품. (+) 풀이arr2.sort(reverse=True)arr2 = sorted(arr2)[::-1]위 두개의 정렬 방법은 동일하다. for i in rang.. 2024. 12. 10. [GROUP BY/LEVEL4] 연간 평가점수에 해당하는 평가 등급 및 성과금 조회하기 (MySQL) MySQLSELECT A.EMP_NO , A.EMP_NAME , CASE WHEN AVG(B.SCORE) >= 96 THEN 'S' WHEN AVG(B.SCORE) >= 90 THEN 'A' WHEN AVG(B.SCORE) >= 80 THEN 'B' ELSE 'C' END AS GRADE , CASE WHEN AVG(B.SCORE) >= 96 THEN A.SAL * 0.2 WHEN AVG(B.SCORE) >= 90 THEN A.SAL * 0.15 WHEN AVG(B.SCORE) >= 80 THEN A.SAL * 0.1 ELSE 0 END AS BONUSFROM HR_.. 2024. 12. 9. 백준 5585번 파이썬 문제 링크 : https://www.acmicpc.net/problem/5585 구현coins = [500, 100, 50, 10, 5, 1]money = 1000 - int(input())cnt = 0for coin in coins: cnt += money // coin money %= coinprint(cnt)그리디 알고리즘 활용 2024. 12. 6. [GROUP BY/LEVEL4] 저자 별 카테고리 별 매출액 집계하기 (MySQL/Oracle) MySQLSELECT A.AUTHOR_ID, B.AUTHOR_NAME, A.CATEGORY, SUM(A.PRICE * C.SALES) AS TOTAL_SALESFROM BOOK A, AUTHOR B, BOOK_SALES CWHERE A.AUTHOR_ID = B.AUTHOR_IDAND A.BOOK_ID = C.BOOK_IDAND YEAR(C.SALES_DATE) = 2022 AND MONTH(C.SALES_DATE) = 1GROUP BY A.AUTHOR_ID, B.AUTHOR_NAME, A.CATEGORYORDER BY A.AUTHOR_ID, A.CATEGORY DESC OracleSELECT A.AUTHOR_ID, B.AUTHOR_NAME, A.CATEGORY, SUM(PRICE * SALES) AS T.. 2024. 12. 5. [GROUP BY/LEVEL3] 부서별 평균 연봉 조회하기 (MySQL) MySQLSELECT A.DEPT_ID, DEPT_NAME_EN, ROUND(AVG(SAL),0) AS AVG_SALFROM HR_DEPARTMENT A, HR_EMPLOYEES BWHERE A.DEPT_ID = B.DEPT_IDGROUP BY DEPT_ID, DEPT_NAME_ENORDER BY AVG_SAL DESC 2024. 12. 4. [GROUP BY/LEVEL3] 대여 횟수가 많은 자동차들의 월별 대여 횟수 구하기 (MySQL) MySQLSELECT MONTH(START_DATE) AS MONTH, CAR_ID, COUNT(*) AS RECORDSFROM CAR_RENTAL_COMPANY_RENTAL_HISTORYWHERE MONTH(START_DATE) BETWEEN 8 AND 10AND (CAR_ID IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE START_DATE BETWEEN '2022-08-01' AND '2022-10-31' GROUP BY CAR_ID HAVING COUNT(CAR_ID) >= 5))GROUP BY MONTH, CAR_IDORDE.. 2024. 12. 3. 이전 1 2 3 4 5 6 ··· 61 다음 728x90 320x100