通过create table table_name as (query expression)这个表达可以将query结果建成新table

create table actor_name
as (select first_name, last_name from actor)