Combining multiple queries to get the result

Hi,
I want to do some calculations but no success , how to convert this in simple and working query, most important variable is $sale_cost. What I would like to achieve is $sale_cost, I am also selecting $sale_cost in another query

Is there any shortcut to do all calculation in few working queries

Any help is very appreciated

slope game

To streamline your workflow, consider using a CTE (Common Table Expression) or a temporary table to calculate sale_cost once and reuse it across multiple queries. For example:

Code:

WITH sales_calculation AS (
    SELECT
        product_id,
        (price * quantity - discount) AS sale_cost  -- Your formula here
    FROM orders
)
-- Query 1: Get sale_cost for specific products
SELECT sale_cost FROM sales_calculation WHERE product_id = 123;
-- Query 2: Aggregate sale_cost (e.g., average)
SELECT AVG(sale_cost) FROM sales_calculation;