개인사

테이블 정보1. MEMBER_PROFILEColumn nameTypeNullableMEMBER_IDVARCHAR(100)FALSEMEMBER_NAMEVARCHAR(50)FALSETLNOVARCHAR(50)TRUEGENDERVARCHAR(1)TRUEDATE_OF_BIRTHDATETRUE  2. REST_REVIEW Column nameTypeNullableREVIEW_IDVARCHAR(10)FALSEREST_IDVARCHAR(10)TRUEMEMBER_IDVARCHAR(100)TRUEREVIEW_SCORENUMBERTRUEREVIEW_TEXTVARCHAR(1000)TRUEREVIEW_DATEDATETRUE  예시 테이블1. MEMBER_PROFILEMEMBER_IDMEMBER_NAMETLNOGENDERDAT..

테이블 정보1. FIRST_HALF NAMETYPENULLABLESHIPMENT_IDINT(N)FALSEFLAVORVARCHAR(N)FALSETOTAL_ORDERINT(N)FALSE 2. JULY NAMETYPENULLABLESHIPMENT_IDINT(N)FALSEFLAVORVARCHAR(N)FALSETOTAL_ORDERINT(N)FALSE 예시 테이블1. FIRST_HALF SHIPMENT_IDFLAVORTOTAL_ORDER101chocolate3200102vanilla2800103mint_chocolate1700104caramel2600105white_chocolate3100106peach2450107watermelon2150108mango2900109strawberry3100110melon31501..

테이블 정보1. FOOD_PRODUCT Column nameTypeNullablePRODUCT_IDVARCHAR(10)FALSEPRODUCT_NAMEVARCHAR(50)FALSEPRODUCT_CDVARCHAR(10)TRUECATEGORYVARCHAR(10)TRUEPRICENUMBERTRUE  2. FOOD_ORDER Column nameTypeNullableORDER_IDVARCHAR(10)FALSEPRODUCT_IDVARCHAR(5)FALSEAMOUNTNUMBERFALSEPRODUCE_DATEDATETRUEIN_DATEDATETRUEOUT_DATEDATETRUEFACTORY_IDVARCHAR(10)FALSEWAREHOUSE_IDVARCHAR(10)FALSE 예시 테이블1. FOOD_PRODUCT PRO..

테이블 정보1. PRODUCTColumn nameTypeNullablePRODUCT_IDINTEGERFALSEPRODUCT_CODEVARCHAR(8)FALSEPRICEINTEGERFALSE  2. OFFLINE_SALEColumn nameTypeNullableOFFLINE_SALE_IDINTEGERFALSEPRODUCT_IDINTEGERFALSESALES_AMOUNTINTEGERFALSESALES_DATEDATEFALSE  예시 테이블1. PRODUCTPRODUCT_IDPRODUCT_CODEPRICE1A1000011150002A100004580003C300000242000  2. OFFLINE_SALEOFFLINE_SALE_IDPRODUCT_IDSALES_AMOUNTSALES_DATE1122022-02-..

테이블 정보1. ANIMAL_INS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSEINTAKE_CONDITIONVARCHAR(N)FALSENAMEVARCHAR(N)TRUESEX_UPON_INTAKEVARCHAR(N)FALSE 2. ANIMAL_OUTS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSENAMEVARCHAR(N)TRUESEX_UPON_OUTCOMEVARCHAR(N)FALSE  예시 테이블1. ANIMAL_INS ANIMAL_IDANIMAL_TYPEDATETIMEINTAKE_CON..

테이블 정보1. ANIMAL_INS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSEINTAKE_CONDITIONVARCHAR(N)FALSENAMEVARCHAR(N)TRUESEX_UPON_INTAKEVARCHAR(N)FALSE 2.ANIMAL_OUTS NAMETYPENULLABLEANIMAL_IDVARCHAR(N)FALSEANIMAL_TYPEVARCHAR(N)FALSEDATETIMEDATETIMEFALSENAMEVARCHAR(N)TRUESEX_UPON_OUTCOMEVARCHAR(N)FALSE 예시 테이블1. ANIMAL_INS ANIMAL_IDANIMAL_TYPEDATETIMEINTAKE_CONDI..

테이블 정보1. CAR_RENTAL_COMPANY_CAR Column nameTypeNullableCAR_IDINTEGERFALSECAR_TYPEVARCHAR(255)FALSEDAILY_FEEINTEGERFALSEOPTIONSVARCHAR(255)FALSE 2. CAR_RENTAL_COMPANY_RENTAL_HISTORY Column nameTypeNullableHISTORY_IDINTEGERFALSECAR_IDINTEGERFALSESTART_DATEDATEFALSEEND_DATEDATEFALSE 3. CAR_RENTAL_COMPANY_DISCOUNT_PLAN Column nameTypeNullablePLAN_IDINTEGERFALSECAR_TYPEVARCHAR(255)FALSEDURATION_TYPEV..

테이블 정보1. FISH_INFO Column nameTypeNullableIDINTEGERFALSEFISH_TYPEINTEGERFALSELENGTHFLOATTRUETIMEDATEFALSE 2. FISH_NAME_INFO Column nameTypeNullableFISH_TYPEINTEGERFALSEFISH_NAMEVARCHARFALSE  예시 테이블1. FISH_INFO IDFISH_TYPELENGTHTIME00302021-12-0410502020-03-0720402020-03-0731202022-03-0941NULL2022-04-0852132021-04-2860602021-07-2770552021-01-1882732020-01-2891732021-04-08102222020-06-28112172022-..

아이디어USED_GOODS_BOARD와 USED_GOODS_REPLY 테이블에서 2022년 10월에 작성된 게시글 제목, 게시글 ID, 댓글 ID, 댓글 작성자 ID, 댓글 내용, 댓글 작성일을 조회하는 SQL문을 작성해주세요. 결과는 댓글 작성일을 기준으로 오름차순 정렬해주시고, 댓글 작성일이 같다면 게시글 제목을 기준으로 오름차순 정렬해주세요. 1. 2022년 10월에 작성된WHERE 1=1AND EXTRACT(YEAR FROM B.CREATED_DATE) = 2022AND EXTRACT(MONTH FROM B.CREATED_DATE) = 10 2. 게시글 제목, 게시글 ID, 댓글 ID, 댓글 작성자 ID, 댓글 내용, 댓글 작성일을 조회하는 SQL문을 작성SELECT B.TITLE, B.BOARD..

아이디어REST_INFO와 REST_REVIEW 테이블에서 서울에 위치한 식당들의 식당 ID, 식당 이름, 음식 종류, 즐겨찾기수, 주소, 리뷰 평균 점수를 조회하는 SQL문을 작성해주세요. 이때 리뷰 평균점수는 소수점 세 번째 자리에서 반올림 해주시고 결과는 평균점수를 기준으로 내림차순 정렬해주시고, 평균점수가 같다면 즐겨찾기수를 기준으로 내림차순 정렬해주세요. 서울에 위치한 식당 = WHERE I.ADDRESS LIKE '서울%'리뷰 평균 점수 = AVG(R.REVIEW_SCORE)리뷰 평균점수는 소수점 세 번째 자리에서 반올림 = ROUND(AVG(R.REVIEW_SCORE),2)평균점수를 기준으로 내림차순 정렬 = ORDER BY 6 DESC평균점수가 같다면 즐겨찾기수를 기준으로 내림차순 정렬 =..