{ let $doc := (collection("vcs_red"))//R for $data in $doc let $grpByValue := data($data/C4) group by $grpByValue return { {distinct-values(data($data/C7))}, {sum(data($data/C7))}, {$grpByValue},1} }