import java.util.*;class Solution { public ArrayList solution(int[] arr) { ArrayList answer = new ArrayList(); ArrayList cnt = new ArrayList(); for(int i=0;i=2){ int s = cnt.get(0); int e = cnt.get(cnt.size()-1); for(int i=s;i

import java.util.*;class Solution { public String solution(String my_string, int[] indices) { StringBuilder sb = new StringBuilder(my_string); Arrays.sort(indices); for (int i = indices.length - 1; i >= 0; i--) { sb.deleteCharAt(indices[i]); } return sb.toString(); }}  String은 변경 불가능한 문자열을 생성하지만, StringBuilder는 변경 가능한 문자열을 만들어 주..

SELECT ORDER_ID, PRODUCT_ID, to_char(out_date,'yyyy-mm-dd') as out_date, case when to_number(to_char(out_date,'yyyymmdd'))20220501 then '출고대기' else '출고미정' end as 출고여부from FOOD_ORDERorder by order_id;

SELECT FOOD_TYPE, REST_ID, REST_NAME, FAVORITESfrom REST_INFOwhere (food_type,favorites) in (select food_type, max(favorites) from rest_info group by food_type)order by food_type desc;

import java.util.*;class Solution { public String solution(String my_string, int m, int c) { ArrayList t = new ArrayList(); String answer = ""; for(int i=0;i

import java.util.*;class Solution { public ArrayList solution(int n, int k) { ArrayList answer = new ArrayList(); for(int i=1;i

SELECT b.CATEGORY, sum(s.sales) as TOTAL_SALESfrom book b, book_sales swhere b.book_id = s.book_idand to_char(SALES_DATE,'yyyy-mm') ='2022-01'group by b.categoryorder by CATEGORY

SELECT to_number(to_char(start_date,'mm')) as MONTH, CAR_ID, count(*) as RECORDSfrom CAR_RENTAL_COMPANY_RENTAL_HISTORY where to_char(start_date,'yyyy-mm-dd') between '2022-08-01' and '2022-10-31' group by to_char(start_date,'mm'), car_idhaving car_id in (select car_id from CAR_RENTAL_COMPANY_RENTAL_HISTORY where to_char(start_date,'yyyy-mm-dd') between '2..