CREATE TABLE people ( firstname varchar(32) not null, lastname varchar(32) not null, extension varchar(8) not null, digit_index varchar(32) ); insert into people (firstname, lastname, extension) values ('john', 'smith','1234'); insert into people (firstname, lastname, extension) values ('eric', 'anderson','5555'); insert into people (firstname, lastname, extension) values ('will', 'example','9124');