已关闭，此问题需要details or clarity。目前不接受答复。
**想改善这个问题吗？**通过editing this post添加详细信息并澄清问题。

昨天关门了。
Improve this question

SELECT
    SUBSTR(A.RECORD_KEY,1,10) AS "PRODUCER_TAX_ID",
    CASE 
        WHEN B.SEX_CODE = 'E' THEN TRIM(B.CORPORATE_NAME) 
        ELSE TRIM(B.FIRST_NAME) || TRIM(B.MIDDLE_NAME) || TRIM(B.LAST_NAME) 
    END AS "PRODUCER_NAME",
    SUBSTR(A.RECORD_KEY,11,2) AS "STATE_CODE",  
    CHAR(C.APPT_LOB_EFF_DT) AS "APPOINTMENT_EFFECTIVE_DATE", 
    A.ORIGINATOR_CD AS "USER_ID",
    CASE A.FILE_MAINT_TRX_CD  
        WHEN 'LOBC' THEN 'UPDATE' 
    END AS "TRANSACTION_TYPE"