select DEPT_CODE, replace(DEPT_NAME, '課', 'グループ') as DEPT_NAME, VALID_FLG
from TBL_DEPT
where VALID_FLG = 1;