我这个mysql查询该如何精简，提高效率啊？

我这个查询语句还能再精简吗？如下代码：

    SELECT
        a.customercode AS "customercode",
        a.customername AS "customername",
        a.customerphone AS "customerphone",
        a.customeraddress AS "customeraddress",
        a.customercarded AS "customercarded",
        ROUND(
            (
                (
                    SELECT
                        SUM(
                            COALESCE (tcl.bjdk, 0) + COALESCE (tcl.yjdk, 0) + COALESCE (tcl.zzje, 0)
                        )
                    FROM
                        customerloan tcl
                    WHERE
                        tcl.customercode = a.customercode
                ) - (
                    SELECT
                        SUM(twl.je)
                    FROM
                        weightlist twl
                    WHERE
                        twl.khbh = a.customercode
                )
            ),
            2
        ) AS "customerloan"
    FROM
        customerarchives a

请大师给我解解闷。