TY_DataFullStack

취소되지 않은 진료 예약 조회하기 select a.pt_no, a.PT_NAME, c.PT_NO, b.MCDP_CD, b.DR_NAME, c.APNT_YMD from appointment c join patient a on a.PT_NO = c.PT_NO join doctor b on c.MDDR_ID = b.DR_ID where c.APNT_CNCL_YN = 'N' and c.mcdp_cd = 'CS' and left(date(c.APNT_YMD),10) = '2022-04-13' 답안 SELECT YEAR(S.Sales_date) AS YEAR, MONTH(S.sales_date) AS MONTH, COUNT(DISTINCT(S.user_id)) AS PURCHASED_USERS, ROUND((COU..

대여 기록이 존재하는 자동차 리스트 구하기 Lv3 SELECT a.car_id from car_rental_company_car a join car_rental_company_rental_history b using (car_id) where b.start_date like '%-10-%' and a.car_type = '세단' group by 1 order by 1 desc 즐겨찾기가 가장 많은 식당 정보 출력하기 Lv3 SELECT food_type, rest_id,rest_name, favorites from rest_info WHERE (FOOD_TYPE,FAVORITES) IN (SELECT FOOD_TYPE, MAX(FAVORITES) FROM REST_INFO GROUP BY FOOD_TYP..

조건에 맞는 도서와 저자 리스트 출력하기 Lv2 SELECT A.BOOK_ID, B.AUTHOR_NAME, DATE_FORMAT(A.PUBLISHED_DATE,'%Y-%m-%d') PUBLISHED_DATE FROM BOOK A JOIN AUTHOR B using (author_id) WHERE A.CATEGORY = '경제' ORDER BY A.PUBLISHED_DATE ASC 상품 별 오프라인 매출 구하기 Lv.2 SELECT A.PRODUCT_CODE, sum(a.price * B.SALES_AMOUNT) SALES FROM PRODUCT A JOIN OFFLINE_SALE B ON a.PRODUCT_ID = b.product_id group by 1 ORDER BY 2 DESC, 1 asc 없어진..