개인사

테이블 정보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. BOOK Column nameTypeNullableDescriptionBOOK_IDINTEGERFALSE도서 IDCATEGORYVARCHAR(N)FALSE카테고리 (경제, 인문, 소설, 생활, 기술)AUTHOR_IDINTEGERFALSE저자 IDPRICEINTEGERFALSE판매가 (원)PUBLISHED_DATEDATEFALSE출판일  2. BOOK_SALES Column nameTypeNullableDescriptionBOOK_IDINTEGERFALSE도서 IDSALES_DATEDATEFALSE판매일SALESINTEGERFALSE판매량   예시 테이블1. BOOK BOOK_IDCATEGORYAUTHOR_IDPRICEPUBLISHED_DATE1인문1100002020-01-012경제1900..

테이블 정보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..

테이블 정보Column nameTypeNullablePRODUCT_IDVARCHAR(10)FALSEPRODUCT_NAMEVARCHAR(50)FALSEPRODUCT_CDVARCHAR(10)TRUECATEGORYVARCHAR(10)TRUEPRICENUMBERTRUE  예시 테이블PRODUCT_IDPRODUCT_NAMEPRODUCT_CDCATEGORYPRICEP0018맛있는고추기름CD_OL00008식용유6100P0019맛있는카놀라유CD_OL00009식용유5100P0020맛있는산초유CD_OL00010식용유6500P0021맛있는케첩CD_OL00001소스4500P0022맛있는마요네즈CD_OL00002소스4700  문제FOOD_PRODUCT 테이블에서 가격이 제일 비싼 식품의 식품 ID, 식품 이름, 식품 코드, 식..

테이블 정보Column nameTypeNullableIDINTEGERFALSEPARENT_IDINTEGERTRUESIZE_OF_COLONYINTEGERFALSEDIFFERENTIATION_DATEDATEFALSEGENOTYPEINTEGERFALSE  예시 테이블IDPARENT_IDSIZE_OF_COLONYDIFFERENTIATION_DATEGENOTYPE1NULL102019-01-0152NULL22019-01-013311002020-01-01442102020-01-01452172020-01-016641012021-01-0122  문제분화된 연도(YEAR), 분화된 연도별 대장균 크기의 편차(YEAR_DEV), 대장균 개체의 ID(ID) 를 출력하는 SQL 문을 작성해주세요. 분화된 연도별 대장균 크기의 ..

테이블 정보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-..