IQuery q = sess.CreateQuery("select g.StudyCategory.StudyCategoryID, g.StudyCategory.Name, count(*) from Grantee g inner join g.Grants gd where gd.Grant.GrantID = :grantID group by g.StudyCategory.StudyCategoryID, g.StudyCategory.Name");

select studycateg3_.studycategoryid as x0_0_,
   studycateg3_.name as x1_0_
from grantees grantee0_ inner join grantee_grants grants1_ on grantee0_.granteeid=grants1_.granteeid inner join grantee_grants grantdetai2_ on grants1_.granteegrantid=grantdetai2_.granteegrantid, study_categories studycateg3_
where grantee0_.studycategoryid=studycateg3_.studycategoryid and ((grantdetai2_.grantid=? ))
group by grantee0_.studycategoryid , studycateg3_.name

IQuery q = sess.CreateQuery("select sc.StudyCategoryID, sc.Name, count(*) from Grantee g inner join g.Grants gd inner join g.StudyCategory sc where gd.Grant.GrantID = :grantID group by sc.StudyCategoryID, sc.Name");

<class name="Grantee" table="grantees" lazy="true">
      <id name="GranteeID" column="granteeid" type="int">
         <generator class="sequence">
            <param name="sequence">grantees_id_seq</param>
         </generator>
      </id>

      <property name="FirstName"      column="firstname"   type="string" />
      <property name="LastName"       column="lastname"    type="string" />
      <property name="EmailPrimary"   column="email1"      type="string" />
      <property name="EmailSecondary" column="email2"      type="string" />
      <property name="Address"        column="address"     type="string" />
      <property name="City"           column="city"        type="string" />
      <property name="Gender"         column="gender"      type="string" />
      <property name="PhoneHome"      column="phonehome"   type="string" />
      <property name="PhoneWork"      column="phonework"   type="string" />
      <property name="PhoneCell"      column="phonecell"   type="string" />
      <property name="ZipCode"        column="zip"         type="string" />
   
    <property name="Active"         column="active"      type="boolean" />
   
    <property name="Birthdate"      column="birthdate"   type="datetime" />
    <property name="Lastupdate"     column="lastupdate"  type="datetime" />


    <many-to-one name="StudyCategory" column="studycategoryid" class="StudyCategory" />
      <many-to-one name="Country"       column="countryid"       class="Country" />
      <many-to-one name="State"         column="stateid"         class="State" />
      
      
      <bag name="Grants" table="grantee_grants" inverse="true" lazy="true">
         <key column="granteeid"/>
         <many-to-many class="GrantDetails" column="granteegrantid" />
      </bag>

    <bag name="Comments" table="grantee_comments" inverse="true" lazy="true">
      <key column="granteeid"/>
      <many-to-many class="GranteeComment" column="granteecommentid" />
    </bag>

    <bag name="Documents" table="grantee_documents" inverse="true" lazy="true">
      <key column="granteeid"/>
      <many-to-many class="GranteeDocument" column="granteedocumentid" />
    </bag>
   </class>

   <class name="StudyCategory" table="study_categories" lazy="true">
      <id name="StudyCategoryID" column="studycategoryid" type="int">
         <generator class="sequence">
            <param name="sequence">studycategories_id_seq</param>
         </generator>
      </id>
      
      <property name="Name" column="name" type="string" />
   </class>

<class name="Grant" table="grants" lazy="true">
      <id name="GrantID" column="grantid" type="int">
         <generator class="sequence">
            <param name="sequence">grants_id_seq</param>
         </generator>
      </id>

      <property name="Name" column="name" type="string" />
      
      <bag name="Grantees" table="grantee_grants" lazy="true">
         <key column="grantid"/>
         <many-to-many class="Grantee" column="granteeid"/>
      </bag>
      
   </class>