--処理1
INSERT INTO DEPARTMENT
SELECT
	'B300'
	,'2023-04-01'
	,'NULL'
	,'新設部門'
	,LAYER
	,UP_DEPT_CODE
	,'1'
	,UPDATE_USER_NAME
	,'2023-04-01 00:00:00'
FROM DEPARTMENT
WHERE DEPT_CODE = 'A100';

-- 処理2
UPDATE DEPARTMENT
SET END_DATE = '2023-03-31'
	,VALID_FLG = '0'
	,UPDATE_USER_NAME = 'ORG_CHG'
	,USER_UPDATE_DATETIME = '2023-03-31 23:59:59'
WHERE DEPT_CODE IN ('A100','A200');

-- 処理3
UPDATE EMP
SET DEPT_CODE ='B300'
	,START_DATE = '2023-04-01'
	,UPDATE_USER_NAME = 'ORG_CHG'
	,USER_UPDATE_DATETIME = '2023-04-01 00:00:00'
WHERE DEPT_CODE IN ('A100','A200')
AND VALID_FLG = '1';

SELECT *
FROM EMP
WHERE DEPT_CODE IN ('A100','A200')
AND VALID_FLG = '1';


SELECT *
FROM DEPARTMENT
WHERE DEPT_CODE IN ('A100','A200');

SELECT *
FROM DEPARTMENT;