类似这样的语句如何用 Spring data JPA 去实现？

    select cm.club_id as clubId, SUM(bt.wait_account) AS tenderTotal,
     cm.user_id as userId, c.club_number as clubNumber, u.username AS userName 
     FROM club_member cm
     LEFT JOIN club c ON cm.club_id = c.id
     LEFT JOIN user u ON cm.user_id = u.user_id
     INNER JOIN borrow_tender bt ON cm.user_id = bt.user_id
     WHERE c. STATUS = 1 AND cm. STATUS = 0
     GROUP BY cm.club_id 
     ORDER BY tenderTotal DESC