This is not supported by Athena as Amazon Athena does not support INSERT or CTAS (Create Table As Select) queries.
Amazon athena stores query result in S3. Here is a documentation on how Athena works. https://docs.aws.amazon.com/athena/latest/ug/querying.html
As Athena only points to data in S3. So once results are in S3, you can use athena to point to this as a new table.