create several tables SQL

[Mina]

I want to know how with SQL query to create several tables, in the same "new SQL query recipe",
example
createtable1
select a, b, c
from source1;

createtable2
select x,y,z
from source2;

thank you

[AlexT]

You could use SQL Script Recipe, https://doc.dataiku.com/dss/latest/code_recipes/sql.html#managing-schema-or-creating-tables