Answer: CREATE TABLE AS SELECT (CTAS)

The CREATE TABLE AS SELECT (CTAS) command is the ideal choice for the data engineer's needs. CTAS allows for the creation of a new table based on the results of a SELECT statement, enabling the engineer to combine data from multiple sources, apply transformations, and store the result in a new table all in one operation. This method is efficient as it both creates a new table and processes data simultaneously, without affecting the original data. For example: ```sql CREATE TABLE new_table AS SELECT id, SUM(amount) as total_amount, AVG(score) as average_score FROM old_table GROUP BY id; ``` This example demonstrates the use of CTAS to generate a new table named `new_table` by aggregating and averaging data from `old_table`. It's a practical approach for creating tables tailored for analysis.

Author: LeetQuiz Editorial Team