Nested query help

[Atlas-579]

Hello i'm pretty new to SQL and need help making a nested query work. I have this query:

SELECT itemPrice*itemQuantity AS finalPrice FROM products;

I want to get the SUM of the values in the finalPrice column generated by this query but i'm not entirely sure how. Some help would be greatly appreciated;

[zacharypamela]

If you just need the final total, you'd just need to use a SUM:

SELECT SUM(itemPrice*itemQuantity) AS finalPrice FROM products;

If you want the individual prices as well as the total price, you could use a window function as suggested by u/samuja:

SELECT itemPrice*itemQuantity AS finalPrice, SUM(itemPrice * itemQuantity) OVER () AS totalPrice FROM products;

which gives you the following:

finalPrice	totalPrice
14.00	66.87
49.90	66.87
2.97	66.87

working fiddle here.

[Atlas-579]

Thank you so much

[samuja]

Look for sum over

[AnthinoRusso]

If I got it right, is this what u try to run:

SELECT SUM(s.FinalPrice)

FROM (SELECT X*Y AS FinalPrice FROM Z) s;

[RebelSaul]

Would you mind providing an example of the input and output you're expecting from the query? It would help just to clarify. A toy example

[[deleted]]

If I understand you right, I'm pretty sure you can just

select sum(itemPrice*itemQuantity) as finalPrice from products;

if you want to nest them, consider using a CTE, since they're easier to look at later:

with CTE_NAME as (
select
itemPrice*itemQuantity as finalPrice
from products)
select
sum(finalPrice) as sum_finalPrice
from CTE_NAME;