✅EASY MYSQL SOLUTION
Intuition\n Describe your first thoughts on how to solve this problem. \n\n# Approach\n Describe your approach to solving the problem. \n\n# Complexity\n- Time 
# Intuition\n<!-- Describe your first thoughts on how to solve this problem. -->\n\n# Approach\n<!-- Describe your approach to solving the problem. -->\n\n# Complexity\n- Time complexity:\n<!-- Add your time complexity here, e.g. $$O(n)$$ -->\n\n- Space complexity:\n<!-- Add your space complexity here, e.g. $$O(n)$$ -->\n\n# Code\n```\n# Write your MySQL query statement below\nSELECT p.product_id, IFNULL(round(SUM(p.price*u.units)/sum(u.units),2),0) as average_price\nFROM Prices p \nLEFT JOIN UnitsSold u\nON p.product_id = u.product_id AND \nu.purchase_date BETWEEN p.Start_date and p.end_date\nGROUP BY p.product_id\n```\n![Upvote.png](https://assets.leetcode.com/users/images/8bbfd48c-38db-4bdd-8928-11088f260c45_1723277982.4851594.png)
['MySQL']