PROGRAMMERS
-
[프로그래머스] [JAVA] [Level 2] [2022 KAKAO BLIND RECRUITMENT] 주차 요금 계산PROGRAMMERS/KAKAO 2022. 10. 21. 13:56
문제 설명 제한사항 입출력 예 import java.util.*; class Solution { // (String)시간을 (Int)min으로 바꿔주는 메소드 public int getMin(String time){ // ex) 15:30 t[0] = 15, t[1] = 30 String t[] = time.split(":"); // ex) int형으로 변환후 15 * 60 + 30 return Integer.valueOf(t[0])*60 + Integer.valueOf(t[1]); } public int[] solution(int[] fees, String[] records) { Map parking = new HashMap(); // 현재 파킹 중인 차들 Map times = new HashMap()..
-
[프로그래머스] [JAVA] [Level 2] [깊이/너비 우선 탐색(DFS/BFS)] 타겟 넘버PROGRAMMERS/깊이&너비 우선 탐색(DFS&BFS) 2022. 10. 20. 13:21
class Solution { int answer = 0; public void dfs(int numbers[], int target, int depth, int sum){ // 탈출 조건 if(depth == numbers.length){ if(target == sum){ answer++; } return; } // 수행 동작 dfs(numbers, target, depth+1, sum + numbers[depth]); dfs(numbers, target, depth+1, sum - numbers[depth]); } public int solution(int[] numbers, int target) { dfs(numbers, target, 0, 0); return answer; } } 참조
-
[프로그래머스] [MySQL] [Level 2] [JOIN] 상품 별 오프라인 매출 구하기PROGRAMMERS/SQL 2022. 10. 14. 01:57
SELECT P.PRODUCT_CODE, (PRICE * AMOUNT) AS SALES FROM PRODUCT P JOIN ( SELECT PRODUCT_ID, SUM(SALES_AMOUNT) AS AMOUNT FROM OFFLINE_SALE GROUP BY PRODUCT_ID ) S ON P.PRODUCT_ID = S.PRODUCT_ID ORDER BY SALES DESC, PRODUCT_CODE;
-
[프로그래머스] [MySQL] [Level 4] [SELECT] 서울에 위치한 식당 목록 출력하기PROGRAMMERS/SQL 2022. 10. 14. 01:37
SELECT A.REST_ID, A.REST_NAME, A.FOOD_TYPE, A.FAVORITES, A.ADDRESS, ROUND(AVG(REVIEW_SCORE),2) AS SCORE FROM REST_INFO AS A LEFT JOIN REST_REVIEW AS B ON A.REST_ID = B.REST_ID WHERE A.ADDRESS LIKE '서울%' AND REVIEW_SCORE IS NOT NULL GROUP BY A.REST_ID ORDER BY SCORE DESC, A.FAVORITES DESC;
-
[프로그래머스] [MySQL] [Level 4] [JOIN] 5월 식품들의 총매출 조회하기PROGRAMMERS/SQL 2022. 10. 14. 00:57
-- 코드를 입력하세요 SELECT A.PRODUCT_ID, A.PRODUCT_NAME , SUM(A.PRICE * B.AMOUNT) AS TOTAL_SALES FROM FOOD_PRODUCT AS A LEFT JOIN FOOD_ORDER AS B ON A.PRODUCT_ID = B.PRODUCT_ID WHERE YEAR(B.PRODUCE_DATE) = 2022 AND MONTH(B.PRODUCE_DATE) = 5 GROUP BY PRODUCT_NAME ORDER BY TOTAL_SALES DESC, A.PRODUCT_ID
-
[프로그래머스] [MySQL] [Level 3] [JOIN] 없어진 기록 찾기PROGRAMMERS/SQL 2022. 10. 13. 22:11
-- 코드를 입력하세요 SELECT A.ANIMAL_ID, A.NAME FROM ANIMAL_OUTS A LEFT OUTER JOIN ANIMAL_INS B ON A.ANIMAL_ID = B.ANIMAL_ID WHERE B.ANIMAL_ID is NULL ORDER BY A.ANIMAL_ID SELECT ANIMAL_OUTS.ANIMAL_ID, ANIMAL_OUTS.NAME FROM ANIMAL_OUTS LEFT JOIN ANIMAL_INS ON ANIMAL_INS.ANIMAL_ID = ANIMAL_OUTS.ANIMAL_ID WHERE ANIMAL_INS.ANIMAL_ID IS NULL ORDER BY ANIMAL_INS.ANIMAL_ID;
-
[프로그래머스] [MySQL] [Level 3] [JOIN] 있었는데요 없었습니다PROGRAMMERS/SQL 2022. 10. 13. 22:01
-- 코드를 입력하세요 SELECT ANIMAL_INS.ANIMAL_ID, ANIMAL_INS.NAME FROM ANIMAL_INS LEFT JOIN ANIMAL_OUTS ON ANIMAL_INS.ANIMAL_ID = ANIMAL_OUTS.ANIMAL_ID WHERE ANIMAL_INS.DATETIME > ANIMAL_OUTS.DATETIME ORDER BY ANIMAL_INS.DATETIME SELECT A.ANIMAL_ID, A.NAME FROM ANIMAL_INS AS A, ANIMAL_OUTS AS B WHERE A.ANIMAL_ID = B.ANIMAL_ID AND A.DATETIME > B.DATETIME ORDER BY A.DATETIME;