Store Amazon Athena Query Results into new Table

I need to store Amazon Athena query results into New Amazon Athena Table.

Solution

Recently they have added Create Table as CTAS support to Athena.

Extract from nested JSON in SQL
In SQL Athena, how can I get a CSV's creation date and time?
AWS Glue cannot create database from crawler: permission denied
How to separate JSON key and value pair in Amazon Athena?
AWS Athena SQL - Multiplying the constant number to existing data
How to test Amazon Athena queries
Querying timestamp data in Athena when the timestamp format in the underlying JSON files has changed
Create AWS Athena view programmatically
Is it possible to partition an Athena table using a variable which is timestamp datatype
How to efficiently store and query data with key-value pair in AWS S3 and Athena?
Error while fetching data from mongo to QuickSight using Athena (COLUMN_NOT_FOUND Error)
How do you escape underscores and single quotes in Amazon Athena queries?
AWS Glue missing permissions
Athena Query - "NOT IN" slow performance
Athena/Presto Escape Underscore
How to query a data using DateTime format while the data stored in table is in Unix Timestamp?
Athena query find till next value
AWS Athena parse JSON array
How do I execute get_query_results after get_query_execution has finished?
Create json object from several columns programmatically in presto/trino/aws athena
AWS Athena Parse array of JSON objects to rows
AWS athena regex replace except first occurrence
Trino string split > every character
How to Create Dataframe from AWS Athena using Boto3 get_query_results method
Amazon s3: Get last updated date of partition in Athena/AWS Glue Catalog
Why does Athena report "The specified key does not exist" when inserting to an Iceberg table?
AWS Managed Grafana timing out when retrieving data from Athena
Athena partitioned table yielding no results
How to query on AWS Athena partitioned table
Trino/Presto SQ: Replace NULL with a value only if the NULL comes after the first non-NULL value in the group