Hi, I have the sas code below and need some help converting it to sql.   select as_of_date, sum(org_book_bal) as prod, sum(cur_yield*org_book_bal)/sum(org_book_bal) as wtd_cur_yield, sum(transfer_rate*org_book_bal)/sum(org_book_bal) as wtd_transfer_rate, sum(liquidity_premium_rate*org_book_balance)/sum(org_book_bal) as wtd_liquidity_rate, sum(option_cost_rate*org_book_balance)/sum(org_book_bal) as wtd_option_cost, sum(all_in_tp_rate*org_book_balance)/sum(org_book_bal) as wtd_all_in_FTP_rate, sum(cur_net_rate*org_book_balance)/sum(org_book_bal) as wtd_net_rate, from ofsaa_atomic.fsi_d_mortgages where datepart(as_of_date)>mdy(1,1,2020) and month(datepart(issue_date))=month(datepart(as_of_date)) and year(datepart(issue_date))=year(datepart(as_of_date)) and data_source_cd=80 group by as_of_date;   I appreciate the help! Thanks       ... View more