title: HQL Order by query giving problem
body: <p>I have following query written in HQL for Hibernate.</p>
  
  <p>========================================================================</p>
  
  <pre><code>select new map(ret.retailerDesc as ret_name, ret.id.retailerId as ret_id,
                 ret.id.serviceId as service_id,  
  
  (select count(distinct i.inspectionId) as inspections from Inspection i 
  inner join i.clgCodeStatus c 
  inner join c.retailerOrderses r  
  inner join r.cusRetailer cr 
  inner join i.inspectionMission m  where ret.id = cr.id  ) as inspections ,
  
  (select count(distinct i.inspectionId) as inspections   from Inspection i 
  inner join i.clgCodeStatus c 
  inner join c.retailerOrderses r 
  inner join r.cusRetailer cr 
  inner join i.inspectionMission m 
  where ret.id = cr.id  and i.inspectionResult = '1'  ) as match,
  
  (select count(distinct i.inspectionId) as inspections   from Inspection i 
  inner join i.clgCodeStatus c 
  inner join c.retailerOrderses r 
  inner join r.cusRetailer cr 
  inner join i.inspectionMission m 
  where ret.id = cr.id  and i.inspectionResult = '0'  ) as mismatch  )
  
  from CusRetailer ret  order by inspections desc
  </code></pre>
  
  <p>=======================================================================</p>
  
  <p>When above query executes it gives following error:</p>
  
  <pre><code>ERROR: column "inspections" does not exist
  </code></pre>
  
  <p>It is giving this error for "order by inspections desc".
  If I remove that it works fine.</p>
  
  <p>Can anyone please help me to resolve this problem?</p>
  
  <p>Thanks.</p>