insert into somedatabase.sometable select distinct username,ddname,college,somedate,id from test_table where somedate>='20180101'and sdate<'20180130';

create table somedatabase.sometable as select distinct username,ddname,college,somedate,id from test_table where somedate>='20180101'and sdate<'20180130';