create table with one column from two fields min and max date from another table

Sorry, it's more then unclear what you mean. How does the bases table look like (DDL), then existing data (DML) and why a new table and not simply a view?