create table tmp_eric as
( select * from ... where ... )
Each columns returned from the select will become the columns of the new table tmp_eric.
create table tmp_eric (col1, INTEGER PRIMARY KEY, col2...)
insert into tmp_eric (col1, col2,...)
select col1, col2,... from eric
You can also use:
select * into tmp_eric from eric