process-y

📄 문제 💡 풀이 SELECT item_id, item_name FROM item_info WHERE item_id IN (SELECT item_id FROM item_tree WHERE parent_item_id IS NULL) ORDER BY item_id

📄 문제 💡 풀이 SELECT animal_id FROM animal_ins WHERE name IS NULL ORDER BY animal_id

📄 문제 💡 풀이 SELECT EXTRACT(MONTH from start_date) month, car_id, COUNT(*) records FROM car_rental_company_rental_history WHERE TO_DATE('2022-08-01','yyyy-MM-dd')

📄 문제 💡 풀이 SELECT car_type, COUNT(*) cars FROM car_rental_company_car WHERE REGEXP_LIKE(options,'통풍시트|열선시트|가죽시트') GROUP BY car_type ORDER BY car_type

📄 문제 💡 풀이 SELECT b.title, b.board_id, r.reply_id, r.writer_id, r.contents, TO_CHAR(r.created_date,'yyyy-MM-dd') created_date FROM used_goods_board b RIGHT JOIN used_goods_reply r ON b.board_id = r.board_id WHERE TO_CHAR(b.created_date,'yyyy-MM') = '2022-10' ORDER BY r.created_date, b.title

📄 문제 💡 풀이 SELECT f.flavor FROM first_half f LEFT JOIN icecream_info i ON f.flavor = i.flavor WHERE total_order >= 3000 AND ingredient_type = 'fruit_based' ORDER BY total_order DESC

📄 문제 💡 풀이 import java.util.*; public class Solution { public int[] solution(int []arr) { List list = new ArrayList(); list.add(arr[0]); for(int i=0; i

📄 문제 💡 풀이 import java.util.Set; import java.util.HashSet; class Solution { public int solution(int[] nums) { Set set = new HashSet(); for(int num : nums) set.add(num); return set.size() > nums.length/2 ? nums.length/2 : set.size(); } }

📄 문제 💡 풀이 SELECT animal_id, animal_type, name FROM animal_outs o WHERE animal_id IN ( SELECT animal_id FROM animal_ins i WHERE SEX_UPON_INTAKE LIKE 'Intact%' AND i.SEX_UPON_INTAKE != o.SEX_UPON_OUTCOME ) ORDER BY 1

📄 문제 💡 풀이 SELECT fp.product_id, product_name, SUM(amount)*price total_sales FROM food_product fp RIGHT JOIN food_order fo ON fp.product_id = fo.product_id WHERE TO_CHAR(produce_date,'yyyy-MM') = '2022-05' GROUP BY fp.product_id, product_name, price ORDER BY total_sales DESC, fp.product_id