Something

create view "SpecificationMatrixVW" ( "SpecificationMatrixId", "SpecMatrixId", "SpecificationCode", "DataColumnTotal", "TestColumnTotal", "ProjectCount", "ProjectId") as 	select c1."SpecificationMatrixId", c1."SpecMatrixId", c1."SpecificationCode", ( SELECT count(SMDC.SpecificationMatrixDataColumnId)  FROM   SpecificationMatrixDataColumn SMDC  WHERE  c1.SpecificationMatrixId = SMDC.SpecificationMatrixId ), ( SELECT count(SMTC.SpecificationTestColumnId)  FROM   SpecificationTestColumn SMTC  WHERE  c1.SpecificationMatrixId = SMTC.SpecificationMatrixId ), ( SELECT count(PSM.ProjectId)   FROM   SpecificationMatrix SM,   ProjectSpecificationMatrix PSM WHERE  SM.SpecificationMatrixId = PSM.SpecificationMatrixId AND   c1.SpecificationCode = SM.SpecificationCode ), c2."ProjectId"  	from "SpecificationMatrix" c1, "ProjectSpecificationMatrix" c2  	where c1."SpecificationMatrixId" = c2."SpecificationMatrixId"  with check option