mysql怎么精简_我这个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

请大师给我解解闷。