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.
CREATE TABLE new_table AS SELECT col1, col2, col3 FROM some_table WHERE ...
This is the syntax I always use, but I have just realized that it not documented in the manual...