create table instructors (empno int primary key,
			  name varchar(20),
			  rank varchar(20),
			  roomno int,
			  telno varchar(10));
			  
insert into instructors values (1, 'John Smith', 'Associate Professor', 100, '123-4567');
insert into instructors values (2, 'Jane Doe', 'Assistant Professor', 110, '321-7643');
insert into instructors values (3, 'Alexa Rogers', 'Professor', 210, '555-5555');
insert into instructors values (4, 'Bob Lee', 'Assistant Professor', 200, '222-8888');

