-
""" 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/181943 """ // 풀이 과정 class Solution { public String solution(String my_string, String overwrite_string, int s) { String answer = ""; int over_length = overwrite_string.length(); int my_length = my_string.length(); if (over_length > my_length){ for (int i = 0; i < over_length; i++){ if (i<s){ answer+=my_string.charAt(i); } else{ answer+=overwrite_string.charAt(i); } } } else{ for (int i = 0; i < my_length; i++){ if (i<s){ answer+=my_string.charAt(i); } else if( i>=s && i< (over_length+s) ){ answer+=overwrite_string.charAt(i-s); } else { answer+=my_string.charAt(i); } } } System.out.print(answer); return answer; } }
-
/* 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/181947 */ //풀이과정 import java.util.Scanner; public class Solution { public static void main(String[] args) { Scanner sc = new Scanner(System.in); int a = sc.nextInt(); int b = sc.nextInt(); System.out.print(String.valueOf(a) +" + "+ String.valueOf(b)+" = "+(a+b)); } }
-
/* 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/181949 */ import java.util.Scanner; public class Solution { public static void main(String[] args) { Scanner sc = new Scanner(System.in); String a = sc.next(); String[] b= a.split(""); String c = ""; for(String alpha: b){ if(alpha.equals(alpha.toUpperCase()) ) { c+=alpha.toLowerCase(); } else { c+=alpha.toUpperCase(); } } System.out.print(c); } }
-
""" 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/181950?language=java """ import java.util.Scanner; public class Solution { public static void main(String[] args) { Scanner sc = new Scanner(System.in); String str = sc.next(); int n = sc.nextInt(); for(int i=0; i<n ; i++){ System.out.print(str); } } }
-
/* 출처: 프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/181951 */ /* import java.util.Scanner; public class Solution { public static void main(String[] args) { Scanner scanner=new Scanner(System.in); String str; str=scanner.nextLine(); System.out.println(str); } } */
-
""" 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/273709 """ #풀이 과정 """ select sum(PRICE) as TOTAL_PRICE from ITEM_INFO where RARITY = 'LEGEND' """
-
""" 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/273710 """ # 풀이 과정 """ select B.ITEM_ID,A.ITEM_NAME from ITEM_INFO as A,ITEM_TREE as B where 1=1 and A.ITEM_ID = B.ITEM_ID and B.PARENT_ITEM_ID is null order by ITEM_ID asc """
-
""" 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/273711 """ # 풀이 과정 """ -- 새로운 테이블의 형태를 조인해서 변환시킨 아이템 id의 이름을 가져오는 방향성 고민 # select A.ITEM_ID "ITEM_ID",B.ITEM_NAME,B.RARITY,B.ITEM_ID # from ITEM_TREE AS A, # (select * # from ITEM_INFO # where RARITY = "RARE") AS B # where B.ITEM_ID = A.PARENT_ITEM_ID # order by A.ITEM_ID desc select C.ITEM_ID,C.ITEM_NAME,C.RARITY from ITEM_INFO AS D, (select B.ITEM_ID,B.PARENT_ITEM_ID,A.RARITY,A.ITEM_NAME from ITEM_INFO AS A, ITEM_TREE AS B where B.ITEM_ID = A.ITEM_ID) AS C where 1=1 and D.ITEM_ID = C.PARENT_ITEM_ID and D.RARITY = "RARE" order by ITEM_ID desc """
-
""" 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/276034 """ # 풀이과정 """ -- 파이썬과 c# 스킬을 포함한 조합 구성 확보 후 테이블 조인 생각 # select ID,EMAIL,FIRST_NAME,LAST_NAME -- 이진법 구성을 보면 이진법 & 처리 생각! select distinct A.ID,A.EMAIL,A.FIRST_NAME,A.LAST_NAME from DEVELOPERS as A, (select * from SKILLCODES where NAME in ('Python','C#')) as B where A.SKILL_CODE & B.CODE = B.CODE order By A.ID asc """
-
""" 출처:프로그래머스, https://school.programmers.co.kr/learn/courses/30/lessons/284527 """ select C.SCORE "SCORE", C.EMP_NO, B.EMP_NAME, B.POSITION, B.EMAIL from HR_DEPARTMENT as A,HR_EMPLOYEES as B, ( select EMP_NO,YEAR ,sum(score) "SCORE" from HR_GRADE group by EMP_NO,YEAR ) as C where B.EMP_NO = C.EMP_NO order by SCORE desc limit 1