Форматирование sql в jpql

помогите SQL запрос написать на JPQL

SELECT *
FROM sec_user
JOIN
(SELECT *
FROM df_department
JOIN df_correspondent ON df_department.correspondent_id = df_correspondent.id
WHERE delete_ts IS NULL) AS s ON sec_user.department_code = s.code
where s.name like '%%