jpa@Query左连接返回Object

1、数据库简略设计

CUSTOM表：


SERVICE_SHEET表：

2、SQL语句设计

SELECT DISTINCT
	a.CUSTOM_NAME,
	a.LATITUDE,
	a.LONGITUDE,
	COUNT( b.CUSTOMER_ID )  AS SUM_OF_SERVICE
FROM　 
	CUSTOM a
LEFT JOIN
	SERVICE_SHEET b
ON
	DISTANCE ( 114.426957，30.513611, a.LONGITUDE, a.LATITUDE ) < 2 
AND
	a.ID = b.CUSTOMER_ID
GROUP BY
	a.CUSTOM_NAME,
	a.LATITUDE,
	a.LONGITUDE
ORDER BY
	a.CUSTOM_NAME
ASC;

查询结果：

3、实体类定义

Custom.java

import javax.persistence.Entity;
import javax.persistence.Id;

@Entity
public class Custom {
   
    @Id
    private Integer ID;
    private Float CUSTOM_NO;
    private Float LONGITUDE;
    private