SELECT DEPT_CODE,REPLACE(DEPT_NAME,"課","グループ")AS DEPT_NAME,VALID_FLG
 FROM TBL_DEPT
 WHERE VALID_FLG="1";