How to create a SQL table whose columns are the result of a SELECT query?

Question

SQL

Something like CREATE TABLE NewT(Col1, SELECT DISTINCT Prod From Old_table).
Just to make it work, preferably in sqlite.

Answer 1

www.sqlite.org/lang_createtable.html

CREATE TABLE NewT AS SELECT DISTINCT Prod From Old_table;