SELECT department_code, department_name, 1
            FROM department
            WHERE status = 0
            ORDER BY department_code