org.hibernate.hql.ast.QuerySyntaxError: unexpected token: ( near line 1, column 26 [select ORGNAME,VAL from ( select(count(o.organizationId
) * 100/ (select count(b.comp_id.bidId) from com.syntel.sb.appl.bo.vendor.SBBid b where b.client.clientId = 166 and b.deletionMark <>1 and b
.bid_status_code = 50 )) as VAL ,org,o.organizationName as ORGNAME from com.syntel.sb.appl.bo.client.SBOrganization o , com.syntel.sb.appl.
bo.client.SBMember m,com.syntel.sb.appl.bo.vendor.SBBid b ,com.syntel.sb.appl.bo.client.SBClient c where o.deletionMark =0 and m.deletionMa
rk = 0 and b.bidStatus.code =50 and b.member.memberId =m.memberId and b.client.clientId = 166and c.clientId=b.client.clientId and c.deletion
Mark<>1 and m.organizationId =o.organizationId group by o.organizationId,o.organizationName order by 1 desc ) where rownum <=10 ]
org.hibernate.hql.ast.QuerySyntaxError: unexpected token: new near line 1, column 64 [select projectOrganization, count(projectOrganization) as inc, new PortfolioCountImpl(portfolio,inc) from com.x.pmo.vo.ProjectImpl group by projectOrganization as organization]