SELECT PAP.SEGMENT1 PROJECT
, PAP.NAME DESCRIPTION, PAP.PROJECT_ID PROJECT_ID
, COUNT ( DISTINCT PAT.TASK_ID ) TASKS_PER_PROJ
FROM PA_PROJECTS PAP
, PA_TASKS_EXPEND_V PAT
WHERE PAP.PROJECT_ID = PAT.PROJECT_ID ( + ) GROUP BY PAP.PROJECT_ID
, PAP.SEGMENT1
, PAP.NAME