목록분류 전체보기 (403)
happy coding
import java.io.*; import java.util.*; public class Main { public static void main(String[] args) throws IOException { BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); int N = Integer.parseInt(br.readLine()); String[][] data = new String[N][2]; for (int i=0 ; i Integer.parseInt(arr[0]))); for (int i=0 ; i
import java.io.*; public class Main { public static void main(String[] args) throws IOException { BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); boolean[] remainderExists = new boolean[42]; // 0부터 41까지의 나머지에 대한 존재 여부 배열 for (int i = 0; i < 10; i++) { int num = Integer.parseInt(br.readLine()); int numCorr = num % 42; remainderExists[numCorr] = true; } int count = 0; for..
import java.io.*; import java.util.*; public class Main { public static void main(String[] args) throws IOException { BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); int N = Integer.parseInt(br.readLine()); String[] words = new String[N]; for (int i=0 ; i< words.length ; i++) { words[i] = br.readLine(); } int minLength = Integer.MAX_VALUE; for (String word : words) { mi..
SELECT B.BOOK_ID, A.AUTHOR_NAME, DATE_FORMAT(B.PUBLISHED_DATE, '%Y-%m-%d') AS PUBLISHED_DATE FROM BOOK B JOIN AUTHOR A ON B.AUTHOR_ID = A.AUTHOR_ID WHERE B.CATEGORY LIKE '%경제%' ORDER BY B.PUBLISHED_DATE;
SELECT P.PRODUCT_CODE, SUM(O.SALES_AMOUNT * P.PRICE) AS SALES FROM PRODUCT P JOIN OFFLINE_SALE O ON P.PRODUCT_ID = O.PRODUCT_ID GROUP BY P.PRODUCT_CODE ORDER BY SALES DESC, P.PRODUCT_CODE ASC;
SELECT CAR_TYPE, COUNT(CAR_TYPE) AS 'CARS' FROM CAR_RENTAL_COMPANY_CAR WHERE OPTIONS LIKE '%통풍시트%' OR OPTIONS LIKE '%열선시트%' OR OPTIONS LIKE '%가죽시트%' GROUP BY CAR_TYPE ORDER BY CAR_TYPE;
SELECT MCDP_CD AS '진료과코드', COUNT(MCDP_CD) AS '5월예약건수' FROM APPOINTMENT WHERE APNT_YMD LIKE '2022-05-%%' GROUP BY MCDP_CD ORDER BY COUNT(MCDP_CD) ASC, MCDP_CD ASC; 왜 맞았지
import java.io.*; import java.util.*; public class Main { public static void main(String[] args) throws IOException { BufferedReader br = new BufferedReader(new InputStreamReader(System.in)); int[] letterArray = new int[26]; // 영문자의 개수는 26개임 String s = br.readLine(); for (int i = 0; i < s.length(); i++){ if ('A'