My homework assignment creating this new table in Access says to create this table, but when I click Run, I get the error "Syntax error in field definition". What am I doing wrong? I copied the below text straight from the book.

/* *** SQL-CREATE-TABLE-WA-03-02 *** */

CREATE TABLE SALESPERSON(

NickName Char(35) NOT NULL,

LastName Char(25) NOT NULL,

FirstName Char(25) NOT NULL,

HireDate Date NOT NULL,

WageRate Numeric NOT NULL,

CommissionRate Numeric NOT NULL,

OfficePhone Char(12) NOT NULL,

EmailAddress Varchar(100) NOT NULL,

CONSTRAINT SALESPERSON_PK PRIMARY KEY (NickName)

);

CREATE TABLE SALESPERSON \( \begin{array}{lll}\text { NickName } & \text { Char(35) } & \text { NOT NULL, } \\ \text { LastName } & \text { Char(25) } & \text { NOT NULL, } \\ \text { FirstName } & \text { Char(25) } & \text { NOT NULL, } \\ \text { HireDate } & \text { Date } & \text { NOT NULL, } \\ \text { WageRate } & \text { Numeric } & \text { NOT NULL, } \\ \text { CommissionRate Numeric } \quad \text { NOT NULL, } \\ \text { OfficePhone } & \text { Char(12) } & \text { NOT NULL, } \\ \text { EmailAddress } & \text { Varchar(100) } & \text { NOT NULL, } \\ \text { CONSTRAINT } & \text { SALESPERSON_PK PRIMARY KEY (NickName) } \\ \text { ); }\end{array} \)