请给出一条复杂的create as select 多张表的语句

以下是一个复杂的CREATE AS SELECT语句示例，涉及多张表：

CREATE TABLE new_table AS SELECT t1.column1, t2.column2, t3.column3 FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id JOIN table3 t3 ON t2.id = t3.id WHERE t1.condition = 'value';