SQL-Creating TAble : Hi So i am stuck with this question.I know table can be created with the select statement.
    

    CREATE TABLE new_orders (ordr_id,order_date DEFAULT SYSDATE,cus_id) AS 
    Select order_id.order_date,customer_id FROM Orders;

Which statement would be true regarding the above question ?

    1.The NEW_ORDERS table would not get created beacuse the default value cannot be specified in the column definition.
    2.The NEW_ORDERS table would get created and only the NOT NULL constraint define on the specified columnns would be passed to the new table.
    3.The NEW_ORDERS table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
    4.The NEW_ORDERS table would get created and all the constraints defined on the specified columns in the orders table would be passed to new Table.

   I think correct answer should be 3,but it's wrong.The correct answer according to my book is 2.I don't get it how ? Can anyone pls help me with the ?
