select s.product_id
, sum((unit_price-purchase_price)*quantity) total_profit
, round(sum(unit_price-purchase_price)/sum(purchase_price)*100,2) profit_margin
from sales_orders s
left join purchase_prices p on s.product_id = p.product_id
group by 1