Hi, I am trying to get a query count # of results on TABLE_A and multiply by sum of TABLE_B.col_c. The # of listed results/rows is unknown and the final answer should be something like (9 results)*(9+8+7+...). Thanks in advance!!
note : I did query below but answer is not correct..
select...