SELECT CONCAT(TRUNCATE(
(SELECT (
(SELECT count(b.shop_id) FROM sos.t_sos_shop_status AS b
LEFT JOIN mbi.t_mbi_merchant_shop AS a ON a.shop_id=b.shop_id
LEFT JOIN sos.t_sos_shop_department AS c ON c.shop_id=a.shop_id
LEFT JOIN nps.t_nps_department AS d ON d.id=c.department_id
WHERE b.lay_status IN (3) AND a.merchant_id=90013458 AND d.whole_name not LIKE "%测试%"
-- 已铺设门店数 / 门店数 100%
)) AS a)/(SELECT (
(SELECT COUNT(b.shop_id) FROM sos.t_sos_shop_status AS b
LEFT JOIN mbi.t_mbi_merchant_shop AS a ON a.shop_id=b.shop_id
LEFT JOIN sos.t_sos_shop_department AS c ON c.shop_id=a.shop_id
LEFT JOIN nps.t_nps_department AS d ON d.id=c.department_id
WHERE d.whole_name not LIKE "%测试%" and a.merchant_id=90013458
-- 乘以100%，保留两位小数
)) AS b)100,2),"%") AS "门店铺设率";

加减乘除运算符运用一致