PostgreSQL 9.5 test sql

SELECT *, "DEPT_CD" FROM "public"."TEST";




UPDATE "public"."TEST" t1
SET "DEPT_CD" = t2."DEPT_CD"
FROM (
SELECT t3."DEPT_CD", t3."GRP_ID", t3."CST_NM" FROM "public"."TEST" t3 WHERE t3."ATTR_CD" = '1' AND COALESCE(t3."DEPT_CD", '') <> ''
)  t2
WHERE t1."GRP_ID" = t2."GRP_ID"
AND t1."CST_NM" = t2."CST_NM"
AND (t1."DEPT_CD" = '' OR  t1."DEPT_CD" IS NULL)




UPDATE "public"."TEST" t1
SET "IDY_CD" = t2."IDY_CD"
FROM (
SELECT t3."IDY_CD", t3."GRP_ID", t3."CST_NM" FROM "public"."TEST" t3 WHERE t3."ATTR_CD" = '1' AND COALESCE(t3."IDY_CD", '') <> ''
)  t2
WHERE t1."GRP_ID" = t2."GRP_ID"
AND t1."CST_NM" = t2."CST_NM"
AND (t1."IDY_CD" = '' OR  t1."IDY_CD" IS NULL)