Q.14.Write a query that counts the number of companies founded and acquired by quarter starting in Q1 2012.
Create the aggregations in two separate queries, then join them.
Q.15.Write a query that ranks investors from the combined dataset above by the total number of investments they have made.
I have done Q.14. Now in Q.15 i am confused that should i again join investments tables(there are 2 of them) ,
if YES then how to use join again in subqueries as I have already used a Full join in Q.14.
IF NO can i use acquisition table for total investments amount as it should be equal to acquisition_amount