create table scientist (id integer, firstname varchar(100), lastname varchar(100), password varchar(8));
insert into scientist (id, firstname, lastname, password) values (1, 'albert', 'einstein', 'emc2');
insert into scientist (id, firstname, lastname, password) values (2, 'isaac', 'newton', 'force');
insert into scientist (id, firstname, lastname, password) values (3, 'marie', 'curie', 'glowin');
SELECT * FROM scientist