AashishNandakumar · September 1, 2024 08:10
diff --git a/1251_average_selling_price.sql b/1251_average_selling_price.sql
 # Write your MySQL query statement below

 select p.product_id, ifnull(round(sum(p.price * u.units) / sum(u.units), 2), 0) as average_price
 from Prices p left join UnitsSold u on p.product_id=u.product_id and u.purchase_date between p.start_date and p.end_date
 group by p.product_id;
	# Write your MySQL query statement below

	select p.product_id, ifnull(round(sum(p.price * u.units) / sum(u.units), 2), 0) as average_price
	from Prices p left join UnitsSold u on p.product_id=u.product_id and u.purchase_date between p.start_date and p.end_date
	group by p.product_id;