Which two statements are true about the creation of the…

Examine the structure of the sales table:

Evaluate the following create table statement:

Which two statements are true about the creation of the SALES1 table?

A.
The SALES1 table is created with no rows but only a structure.

B.
The SALES1 table would have primary key and unique constraints on the specified columns.

C.
The SALES1 table would not be created because of the invalid where clause.

D.
The SALES1 table would have not null and unique constraints on the specified columns.

E.
The SALES1 table would not be created because column-specified names in the select and create table
clauses do not match,

Explanation:
A: the WHERE clause 1=2 is false so no rows will be inserted into the new table.
D: The NOT NULL constraints will be included in the new table. There are no UNIQUE constraints.