convert sql into hql : I have written the code whch includes sql queries but i neeed

[nitin78]

I have written the code whch includes sql queries but i neeed to convert into hql how should i do....

the sql query is :

String sqlListSurveys= "select distinct s.surveyAutoID, s.surveyTitle, date(s.modifiedOn) modifiedOn, s.createdOn, "
                + "( CASE s.surveyState WHEN '0' THEN 'Created' WHEN '1' THEN 'Published' "
                + " ELSE 'UnPublished' END ) surveyState, s.createdby createdby, (select ifnull(max(respondentID),0) FROM response, survey sur where surveyID = sur.surveyAutoID and sur.surveyAutoID=s.surveyAutoID) respondentID "
                + " from survey s left outer join  response r  on r.surveyID = s.surveyAutoID "
                + " where createdby = "+userId+" and surveyState != '"+SGSConstants.DELETE_STATE+"' order by createdOn DESC";
 
 
         logger.info(sqlListSurveys);
 
         Query queryListSurveys  = sessionFactory.getCurrentSession().createSQLQuery(sqlListSurveys).setParameter("surveyList",result);
         queryListSurveys .setResultTransformer(Transformers.aliasToBean(Survey.class));
         result = queryListSurveys .list();
         map.put("surveyList", result);