Q:

Using a group by to group a select statement

Using a group by to group a select stament
SELECT
    k.Ivalue, k.JOBDESCRIPTION , 
    count( k.Ivalue) as TOTAL 
FROM
    (SELECT  
        a."ID" as Ivalue, b."JOBDESCRIPTION", rq."CURRENTSTATUS" 
     FROM 
        tblG2o_Requests a
     INNER JOIN
        tblG2o_JOBS b ON a."JOBPOSTID" = b."ID"
     INNER JOIN
        (SELECT 
            r.REQUESTID, ir."CURRENTSTATUS" 
         FROM 
            TBLG2O_RESULTSPOOL r 
         INNER JOIN 
            tblG2o_Requests ir ON r.RequestID = ir."ID" 
         WHERE 
            r.ShortListed = '1') rq ON rq.REQUESTID = a."ID"
     WHERE
         "ACTIVE" = '1' 
         AND "DATECOMPLETED" IS NULL
     ORDER BY 
         "REQUESTDATE" DESC) k 
GROUP BY 
    k.JOBDESCRIPTION 

A:

What is the question? You seem to be missing the group by clause, and you do not need double quotes around field names unless you have spaces in them, and even then, if TSQL for example, you would use [] in preference.
I had to remove an ORDER BY in the subquery, that isn't allowed unless other conditions demand it (like TOP n in TSQL)
SELECT
      k.Ivalue
    , k.JOBDESCRIPTION
    , COUNT(k.Ivalue) AS TOTAL
FROM (
            SELECT
                  a.ID AS Ivalue
                , b.JOBDESCRIPTION
                , rq.CURRENTSTATUS
            FROM tblG2o_Requests a

                  INNER JOIN tblG2o_JOBS b
                              ON a.JOBPOSTID = b.ID
                  INNER JOIN (
                              SELECT
                                    r.REQUESTID
                                  , ir.CURRENTSTATUS
                              FROM TBLG2O_RESULTSPOOL r
                                    INNER JOIN tblG2o_Requests ir
                                                ON r.RequestID = ir.ID
                              WHERE r.ShortListed = '1'
                        ) rqenter
                              ON rq.REQUESTID = a.ID
            WHERE ACTIVE = '1'
                  AND DATECOMPLETED IS NULL
      ) k
GROUP BY
      k.Ivalue
    , k.JOBDESCRIPTION

