//MENAMPILKAN SELURUH DATA PROJECT DAN TOTAL CATEGORY MASING-MASING PADA TABEL PROJECT

SELECT projectName, to_char(projectDate, 'DD-Month-YYYY') AS projectDate, projectCost, string_agg(ProjectCategory.categoryName, ', ') 
AS ProjectCategory, TotalCategory FROM Project 
INNER JOIN ProjectCategory ON ProjectCategory.categoryid = ANY (string_to_array(Project.categoryid,','))
INNER JOIN(
  SELECT Project.projectid, COUNT(ProjectCategory.categoryid) AS TotalCategory from Project
  INNER JOIN projectcategory ON ProjectCategory.categoryid = ANY (string_to_array(Project.categoryid,','))
  GROUP BY Project.projectid) 
AS Hasil ON Project.projectid = Hasil.projectid
GROUP BY Project.projectid, Hasil.TotalCategory;