How to simplify calculations using queries?

I am attempting to perform some calculations but have been unsuccessful thus far. The primary variable involved in these calculations is $sale_cost, and my ultimate goal is to obtain its value. Additionally, I am currently selecting $sale_cost in another query.

I am seeking a simplified and effective approach to performing koows these calculations, ideally through a few efficient queries. Any assistance with this matter would be greatly appreciated.