CREATE TABLE emails (email TEXT	NOT NULL);

INSERT INTO emails (email) VALUES ('jim.smith@gmail.com');
INSERT INTO emails (email) VALUES ('jimsmith@gmail');
INSERT INTO emails (email) VALUES ('johndoe@yahoo.com.mx');
INSERT INTO emails (email) VALUES ('winston.smith@maths.ox.ac.uk');
INSERT INTO emails (email) VALUES ('jane.doe@sjfdhdhsnns.com');
INSERT INTO emails (email) VALUES ('unclesam@irs.gov');
INSERT INTO emails (email) VALUES ('retiredvp@ibm.com');