- Write a query that counts the number of companies acquired within 3 years, 5 years, and 10 years of being founded (in 3 separate columns). Include a column for total companies acquired as well. Group by category and limit to only rows with a founding date. (USE CRUNCHBASE Dataset)
for the question above i am not able to get 3 years ,5,years or 10 years as difference between acquired_at_cleaned and founded_at_clean, should i use subquery here and also how to get difference of 3 ,5 or 10 years using two tables?