Multiple query from multiple tables IN ONE TABLE

CREATE TABLE NewTable AS
SELECT
    (SELECT name FROM table1) AS Name,
    (SELECT date FROM table2) AS Date,
    (SELECT SUM(qty) FROM table3 GROUP BY name) AS QTY,
    (SELECT name FROM table3) AS NameY;

SELECT t1.name AS Name, t2.date AS Date, t3.qty AS QTY, t3.name AS NameY
INTO newTable
FROM table1 t1
CROSS JOIN table2 t2
LEFT JOIN (
    SELECT name, SUM(qty) AS qty
    FROM table3
    GROUP BY name
) t3 ON t1.name = t3.name;

CREATE TABLE new_table AS
SELECT
    t1.name AS Name,
    t2.date AS Date,
    t3_sum.qty AS QTY,
    t3.name AS NameY
FROM
    table1 t1
    JOIN table2 t2 ON 
    JOIN (SELECT name, SUM(qty) AS qty FROM table3 GROUP BY name) t3_sum ON t1.name = t3_sum.name
    JOIN table3 t3 ON ;