Consider the following TSQL DDL statement: CREATE TABLE EMP (ID int NOT NULL, F_NAME varchar(30) NOT NULL, L_NAME varchar(30) NOT NULL, AGE int NULL, GENDER varchar (1) NULL 1 Which of the following statements will correctly insert data into this table? A. INSERT INTO EMP VALUES (100, 'Chris', 'Brown', 26, 'MALE') B. INSERT INTO EMP (AGE, GENDER, ID, F_NAME, L_NAME, ) VALUES (26, 'M', 100, 'Chris', 'Brown') C. INSERT INTO EMP ('100', 'Chris', 'Brown', 26, 'MALE') D. INSERT INTO EMP (AGE, GENDER, ID, F_NAME, L_NAME, ) VALUES (26, 100, 'Chris', 'Brown')