How to split the result of a SQL query?

Question

SQL

SELECT * FROM (SELECT sum(val) from vals where (select (id) from val_names));

At the output, I get three numbers (calculated sums) together in descending order. How to divide the received numbers?

Answer 1

At the output, you most likely get one single number, because you don’t have any grouping, and by default SUM () sums all the rows in the selection.
Well, the WHERE condition is absolutely incomprehensible to you.