TIL(Today I Learned)_데일리루틴_24.12.10.Tue

데일리루틴 SQLMySQL 우유와 요거트가 담긴 장바구니 정답입니다.SELECT CART_IDFROM CART_PRODUCTSWHERE NAME = 'Milk' AND CART_ID IN ( SELECT CART_ID FROM CART_PRODUCTS WHERE NAME = 'Yogurt' )ORDER BY CART_ID;데일리루틴 알고리즘Java 문자열 나누기 정답입니다.class Solution { public int solution(String s) { int answer = 0; int countX = 0; int countOther = 0; char x = 0; ..

• format_list_bulleted Sparta/데일리루틴
• · 2024. 12. 10.
• textsms

TIL(Today I Learned)_데일리루틴_24.12.09.Mon

데일리루틴 SQLMySQL 헤비 유저가 소유한 장소 정답입니다.SELECT ID, NAME, HOST_IDFROM PLACESWHERE HOST_ID IN ( SELECT HOST_ID FROM PLACES GROUP BY HOST_ID HAVING COUNT(*) >= 2)ORDER BY ID데일리루틴 알고리즘Java 체육복 정답입니다.import java.util.*;class Solution { public int solution(int n, int[] lost, int[] reserve) { // 학생들의 체육복 보유 상태를 나타낼 배열 int[] students = new int[n]; Arrays.fill(students, 1);..

• format_list_bulleted Sparta/데일리루틴
• · 2024. 12. 9.
• textsms

TIL(Today I Learned)_데일리루틴_24.12.08.Sun

데일리루틴 SQLMySQL 자동차 평균 대여 기간 구하기 정답입니다.SELECT CAR_ID, ROUND(AVG(DATEDIFF(END_DATE, START_DATE) + 1), 1) AS AVERAGE_DURATIONFROM CAR_RENTAL_COMPANY_RENTAL_HISTORYGROUP BY CAR_IDHAVING AVERAGE_DURATION >= 7ORDER BY AVERAGE_DURATION DESC, CAR_ID DESC데일리루틴 알고리즘Java 숫자 짝궁 정답입니다.import java.util.*;class Solution { public String solution(String X, String Y) { // 각 숫자의 빈도를 저장할..

• format_list_bulleted Sparta/데일리루틴
• · 2024. 12. 8.
• textsms

TIL(Today I Learned)_데일리루틴_24.12.07.Sat

데일리루틴 SQLMySQL 자동차 대여 기록에서 장기/단기 대여 구분하기 정답입니다.SELECT HISTORY_ID, CAR_ID, DATE_FORMAT(START_DATE, '%Y-%m-%d') AS START_DATE, DATE_FORMAT(END_DATE, '%Y-%m-%d') AS END_DATE, CASE WHEN DATEDIFF(END_DATE, START_DATE) >= 29 THEN '장기 대여' ELSE '단기 대여' END AS RENT_TYPEFROM CAR_RENTAL_COMPANY_RENTAL_HISTORYWHERE DATE_FORMAT(START_DATE, '%Y-%m') = '2022-09'ORDER BY HISTORY..

• format_list_bulleted Sparta/데일리루틴
• · 2024. 12. 7.
• textsms

TIL(Today I Learned)_데일리루틴_24.12.06.Fri

데일리루틴 SQLMySQL 서울에 위치한 식당 목록 출력하기 정답입니다.SELECT I.REST_ID, I.REST_NAME, I.FOOD_TYPE, I.FAVORITES, I.ADDRESS, ROUND(AVG(R.REVIEW_SCORE), 2) AS SCOREFROM REST_INFO I LEFT JOIN REST_REVIEW RON I.REST_ID = R.REST_IDWHERE I.ADDRESS LIKE '서울%'GROUP BY I.REST_ID, I.REST_NAME, I.FOOD_TYPE, I.FAVORITES, I.ADDRESSHAVING AVG(R.REVIEW_SCORE) IS NOT NULLORDER BY..

• format_list_bulleted Sparta/데일리루틴
• · 2024. 12. 6.
• textsms

TIL(Today I Learned)_데일리루틴_24.12.05.Thr

데일리루틴 SQLMySQL 년, 월, 성별 별 상품 구매 회원 수 구하기 정답입니다.SELECT YEAR(S.SALES_DATE) AS YEAR, MONTH(S.SALES_DATE) AS MONTH, U.GENDER, COUNT(DISTINCT S.USER_ID) AS USERSFROM ONLINE_SALE SJOIN USER_INFO UON S.USER_ID = U.USER_IDWHERE U.GENDER IS NOT NULLGROUP BY YEAR(S.SALES_DATE), MONTH(S.SALES_DATE), U.GENDERORDER BY YEAR(S.SALES_DATE), MONTH(S.SALES_DATE), U.GENDER;데일리루..

• format_list_bulleted Sparta/데일리루틴
• · 2024. 12. 5.
• textsms