내국인근로자 (정보통신업)

Exception in thread "main" java.lang.UnsupportedClassVersionError: com/zaxxer/hikari/HikariConfig has been compiled by a more recent version of the Java Runtime (class file version 55.0), this version of the Java Runtime only recognizes class file versions up to 52.0 at java.lang.ClassLoader.defineClass1( Native Method ) at java.lang.ClassLoader.defineClass( ClassLoader.java:763 ) at java.security.SecureClassLoader.defineClass( SecureClassLoader.java:142 ) at java.net.URLClassLoader.defineClass( URLClassLoader.java:468 ) at java.net.URLClassLoader.access$100( URLClassLoader.java:74 ) at java.net.URLClassLoader$1.run( URLClassLoader.java:369 ) at java.net.URLClassLoader$1.run( URLClassLoader.java:363 ) at java.security.AccessController.doPrivileged( Native Method ) at java.net.URLClassLoader.findClass( URLClassLoader.java:362 ) at java.lang.ClassLoader.loadClass( ClassLoader.java:424 ) at sun.misc.Launcher$AppClassLoader.loadClass( Launcher.java:349 ) at java.lang....

--Oracle SELECT F. FLAVOR FROM FIRST_HALF F RIGHT JOIN ICECREAM_INFO I ON F. FLAVOR = I. FLAVOR WHERE F. TOTAL_ORDER > 3000 AND I. INGREDIENT_TYPE = 'fruit_based' ORDER BY F. TOTAL_ORDER DESC --Mysql SELECT F. FLAVOR FROM FIRST_HALF F JOIN ICECREAM_INFO I ON F. FLAVOR = I. FLAVOR WHERE F. TOTAL_ORDER > 3000 AND I. INGREDIENT_TYPE = "fruit_based" ORDER BY F. TOTAL_ORDER DESC

--Mysql SELECT O. ANIMAL_ID , O. NAME FROM ANIMAL_OUTS AS O LEFT JOIN ANIMAL_INS AS I ON O. ANIMAL_ID = I. ANIMAL_ID WHERE I. ANIMAL_ID IS NULL; --Oracle SELECT O. ANIMAL_ID , O. NAME FROM ANIMAL_INS I RIGHT JOIN ANIMAL_OUTS O ON I. ANIMAL_ID = O. ANIMAL_ID WHERE I. ANIMAL_ID IS NULL ORDER BY O. ANIMAL_ID ;

--Mysql 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_TYPE ) ORDER BY FOOD_TYPE DESC; --Oracle 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_TYPE ) ORDER BY FOOD_TYPE DESC;

--Mysql SELECT A. ANIMAL_ID , A. NAME FROM ANIMAL_INS A , ANIMAL_OUTS B WHERE A. ANIMAL_ID = B. ANIMAL_ID ORDER BY B. DATETIME - A. DATETIME DESC LIMIT 2 --Oracle SELECT ANIMAL_ID , NAME FROM ( SELECT A. ANIMAL_ID , A. NAME FROM ANIMAL_INS A JOIN ANIMAL_OUTS B ON A. ANIMAL_ID = B. ANIMAL_ID ORDER BY B. DATETIME - A. DATETIME DESC ) WHERE ROWNUM <= 2

--Mysql SELECT R. REST_ID , I. REST_NAME , I. FOOD_TYPE , I. FAVORITES , I. ADDRESS , ROUND( AVG (R. REVIEW_SCORE ) , 2 ) AS SCORE FROM REST_REVIEW R JOIN REST_INFO I ON R. REST_ID = I. REST_ID GROUP BY R. REST_ID HAVING I. ADDRESS LIKE ' 서울 %' ORDER BY SCORE DESC, I. FAVORITES DESC --Oracle SELECT I. REST_ID , I. REST_NAME , I. FOOD_TYPE , I. FAVORITES , I. ADDRESS , R.SCORE FROM REST_INFO I INNER JOIN ( SELECT REST_ID , ROUND( AVG ( REVIEW_SCORE ) , 2 ) SCORE FROM REST_REVIEW GROUP BY REST_ID ) R ON I. REST_ID = R. REST_ID WHERE I. ADDRESS LIKE ' 서울 %' ORDER BY R.SCORE DESC, I. FAVORITES DESC

--Mysql SELECT CATEGORY , PRICE AS MAX_PRICE , PRODUCT_NAME FROM ( SELECT CATEGORY , ROW_NUMBER() OVER ( PARTITION BY CATEGORY ORDER BY PRICE DESC ) AS RANKING , PRODUCT_NAME , PRICE FROM FOOD_PRODUCT WHERE CATEGORY IN ( ' 과자 ' , ' 국 ' , ' 김치 ' , ' 식용유 ' ) ORDER BY PRICE DESC ) AS TEMP WHERE RANKING = '1' ORDER BY PRICE DESC -- Oracle SELECT CATEGORY , PRICE AS MAX_PRICE , PRODUCT_NAME FROM FOOD_PRODUCT WHERE ( CATEGORY , PRICE ) IN ( SELECT CATEGORY , MAX ( PRICE ) FROM FOOD_PRODUCT WHERE CATEGORY IN ( ' 과자 ' , ' 국 ' , ' 김치 ' , ' 식용유 ' ) GROUP BY CATEGORY ) ORDER BY MAX_PRICE DESC;

SELECT * FROM ANIMAL_INS ORDER BY ANIMAL_ID ASC;

-- Mysql SELECT BOOK_ID , DATE_FORMAT( PUBLISHED_DATE , '%Y-%m-%d' ) AS PUBLISHED_DATE FROM BOOK WHERE CATEGORY = ' 인문 ' AND YEAR (PUBLISHED_DATE) = 2021 ORDER BY PUBLISHED_DATE ; --Oracle SELECT BOOK_ID , TO_CHAR( PUBLISHED_DATE , 'YYYY-MM-DD' ) PUBLISHED_DATE FROM BOOK WHERE CATEGORY = ' 인문 ' AND TO_CHAR( PUBLISHED_DATE , 'YYYY' ) = '2021' ORDER BY PUBLISHED_DATE ASC;

-- Oracle SELECT B. TITLE AS TITLE , B. BOARD_ID AS BOARD_ID , R. REPLY_ID AS REPLY_ID , R. WRITER_ID AS WRITER_ID , R. CONTENTS AS CONTENTS , TO_CHAR(R. CREATED_DATE , 'yyyy-mm-dd' ) AS CREATED_DATE FROM USED_GOODS_BOARD B , USED_GOODS_REPLY R WHERE B. BOARD_ID = R. BOARD_ID AND B. CREATED_DATE BETWEEN TO_DATE( '2022-10-01' , 'yyyy-mm-dd' ) AND TO_DATE( '2022-10-31' , 'yyyy-mm-dd' ) ORDER BY R. CREATED_DATE ASC, B. TITLE ASC --Mysql SELECT B. TITLE AS TITLE , B. BOARD_ID AS BOARD_ID , R. REPLY_ID AS REPLY_ID , R. WRITER_ID AS WRITER_ID , R. CONTENTS AS CONTENTS , DATE_FORMAT(R. CREATED_DATE , '%Y-%m-%d' ) as CREATED_DATE FROM USED_GOODS_BOARD B JOIN USED_GOODS_REPLY R ON B. BOARD_ID = R. BOARD_ID WHERE B. CREATED_DATE LIKE '2022-10%' ORDER BY R. CREATED_DATE ASC, B. TITLE ASC

--Mysql SELECT ANIMAL_ID , NAME , CASE WHEN ( SEX_UPON_INTAKE LIKE '%NEUTERED%' OR SEX_UPON_INTAKE LIKE '%SPAYED%' ) THEN 'O' ELSE 'X' END AS ' 중성화 ' FROM ANIMAL_INS ORDER BY ANIMAL_ID ASC -Oracle SELECT ANIMAL_ID , NAME , CASE WHEN SEX_UPON_INTAKE LIKE 'Neutered%' OR SEX_UPON_INTAKE LIKE 'Spayed%' THEN 'O' ELSE 'X' END AS 중성화 FROM ANIMAL_INS ORDER BY ANIMAL_ID ;

--MySQL SELECT WAREHOUSE_ID , WAREHOUSE_NAME , ADDRESS , IF( FREEZER_YN IS NULL, 'N' , FREEZER_YN ) AS FREEZER_YN FROM FOOD_WAREHOUSE WHERE ADDRESS LIKE ' 경기도 %' --Oracle SELECT WAREHOUSE_ID , WAREHOUSE_NAME , ADDRESS , NVL( FREEZER_YN , 'N' ) AS FREEZER_YN FROM FOOD_WAREHOUSE WHERE ADDRESS LIKE '% 경기도 %' ORDER BY WAREHOUSE_ID

SELECT * FROM FOOD_PRODUCT WHERE PRICE = ( SELECT MAX ( PRICE ) FROM FOOD_PRODUCT ) 서브쿼리... * 를 안 쓰고 컬럼명을 적어주면 오류가 나는 신비한 문제... (-.-)

--MySQL SELECT ANIMAL_ID , NAME , DATE_FORMAT( DATETIME , '%Y-%m-%d' ) AS 날짜 FROM ANIMAL_INS --Oracle SELECT ANIMAL_ID , NAME , TO_CHAR( DATETIME , 'YYYY-MM-DD' ) AS 날짜 FROM ANIMAL_INS ORDER BY ANIMAL_ID

--MySQL SELECT ANIMAL_TYPE , IFNULL( NAME , 'No name' ) AS NAME, SEX_UPON_INTAKE FROM ANIMAL_INS --Oracle SELECT ANIMAL_TYPE , NVL( NAME , 'No name' ) AS NAME, SEX_UPON_INTAKE FROM ANIMAL_INS ORDER BY ANIMAL_ID ; SELECT ANIMAL_TYPE , DECODE( NAME , NULL, 'No name' , NAME ) AS NAME, SEX_UPON_INTAKE FROM ANIMAL_INS ORDER BY ANIMAL_ID ;

--Oracle SELECT HISTORY_ID , CAR_ID , TO_CHAR( START_DATE , 'YYYY-MM-DD' ) AS START_DATE , TO_CHAR( END_DATE , 'YYYY-MM-DD' ) AS END_DATE , CASE WHEN END_DATE - START_DATE + 1 >= 30 THEN ' 장기 대여 ' ELSE ' 단기 대여 ' END AS RENT_TYPE FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE TO_CHAR( START_DATE , 'YYYYMM' ) = '202209' ORDER BY HISTORY_ID DESC; --MySQL 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 ) + 1 >= 30 THEN " 장기 대여 " ELSE " 단기 대여 " END AS RENT_TYPE FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY WHERE START_DATE BETWEEN '202...

SELECT FLAVOR FROM FIRST_HALF ORDER BY TOTAL_ORDER DESC;

--Mysql SELECT ROUND( AVG ( DAILY_FEE ) , 0 ) AS AVERAGE_FEE FROM CAR_RENTAL_COMPANY_CAR WHERE CAR_TYPE = "SUV" --Oracle SELECT ROUND( AVG ( DAILY_FEE )) AS AVERAGE_FEE FROM CAR_RENTAL_COMPANY_CAR WHERE CAR_TYPE = 'SUV'

--Oracle SELECT CART_ID FROM CART_PRODUCTS WHERE NAME = 'Milk' INTERSECT SELECT CART_ID FROM CART_PRODUCTS WHERE NAME = 'Yogurt' ORDER BY CART_ID ; --Mysql SELECT DISTINCT C . CART_ID FROM CART_PRODUCTS C, CART_PRODUCTS T WHERE C . CART_ID = T. CART_ID AND ( C . NAME = 'Milk' AND T. NAME = 'Yogurt' ) ORDER BY C . CART_ID ; -- Both SELECT CART_ID FROM CART_PRODUCTS WHERE CART_ID IN ( SELECT CART_ID FROM CART_PRODUCTS WHERE NAME = 'Milk' ) AND NAME = 'Yogurt' ORDER BY CART_ID ;

--MYSQL SELECT APP. APNT_NO , P. PT_NAME , P. PT_NO , D. MCDP_CD , D. DR_NAME , APP. APNT_YMD FROM APPOINTMENT APP JOIN PATIENT P ON APP. PT_NO = P. PT_NO JOIN DOCTOR D on APP. MDDR_ID = D. DR_ID where D. MCDP_CD = "CS" AND APP. APNT_YMD LIKE "%2022-04-13%" AND APP. APNT_CNCL_YN = "N" ORDER BY APP. APNT_YMD ; --ORACLE SELECT APP. APNT_NO , P. PT_NAME , P. PT_NO , D. MCDP_CD , D. DR_NAME , APP. APNT_YMD FROM APPOINTMENT APP JOIN PATIENT P ON APP. PT_NO = P. PT_NO JOIN DOCTOR D on APP. MDDR_ID = D. DR_ID WHERE TO_CHAR(APP. APNT_YMD , 'YYYYMMDD' ) = '20220413' AND APP. APNT_CNCL_YN = 'N' AND APP. APNT_CNCL_YMD IS NULL ORDER BY APP. APNT_YMD