cannot enter the data every third row and sum 1 column

cannot input query data every third row on the target google sheets

tried query and appscript

trying to sum column 9 value using the unique values of columns 6,5 and 7 and enter the data every third row on the target sheet from the source.