Remake sql with criteria api(hibernate)?

Question

Java

Hello everyone, I ask you to help translate the sql query into the criteria api format.
SELECT name FROM sys_accounts WHERE guid=(SELECT account_guid FROM sys_activities WHERE (extract(day from now() - datefinish))>30 ORDER BY datefinish DESC LIMIT 1.
This query cannot be used in hibernate, because the limit construct is not supported. The second way is to use the criteria api, but I can't figure it out yet
In general, the company has tasks (oneToMany c) , you need to get a list of companies that have more than 30 days since the last closed task