使用@Query注解报错，SQl怎么转换成HQL

SELECT soft_info.*,soft_version.*,COUNT(DISTINCT soft_version.soft_info_id)
FROM soft_info,soft_version
WHERE soft_info.id = soft_version.soft_info_id
GROUP BY soft_version.soft_info_id
ORDER BY soft_version.update_time DESC_

1.FROM soft_info,soft_version 直接换成对象
2.soft_info.*,soft_version.*,COUNT(DISTINCT soft_version.soft_info_id)换成对象对应的属性字段