Convert a SQL query to HQL

Question

Hi

my question is simple but may a little bit rude. Could please one of you convert two SQL Query to hql :>

Select statistic.* FROM statistic INNER JOIN (SELECT MAX(st_id) AS id " +
"FROM statistic WHERE status = 'N' GROUP BY bc_id) ids ON statistic.st_id = ids.id" +
"ORDER BY bussinessprocessID;

Select post_id, u_post_id FROM statistic INNER JOIN (SELECT MAX(st_id) AS id " +
"FROM statistic WHERE status = 'N' GROUP BY bc_id) ids ON statistic.st_id = ids.id" +
"ORDER BY bussinessprocessID;

Thank you very much

Greetings