insert retrieved data into a new table

Readers,

Is it possible to use the result of a SELECT function to populate a
new table? The objective is to write the new table for use by gnuplot.

The SELECT function features a mathematical operator such as SUM which
obtains a value. Is it possible to use the value from this function to
be entered into the new table. Please advise the relevant parts of the
documentation to read.

Thanks.