sum

I am using a database with multiple dates and would like to sum the values of the last available date, I can filter the data. ... t;% filter(data == max(dados$data)) %>% select(-grep("obitosAcumulados", colnames(dados))) %>% colSums(dados[3])

How can I use two joins in a row, and the second will use the table data generated by the first? I want it to relate the Join ... odes.enderecoamigo.tabela2` ) AS D ON C.parte3 = D.Reg_geral AND C.parte4 = D.Cad_PF GROUP by amigo, casa_do_amigo