US witnesses $4.4bn of investments for residential, commercial and community solar projects since Q4 2022