Provide me with all main products (which are not present in the sub products) with their lowest

I hope you are doing well, please find the problem statement below along with the sample data and output.    I have data with a product, sub-product, level and multiplying factor. Each product has ...