create databease database1
create table employee
(
eid int primary key identity(1,1),
ename varchar(20),
ejob varchar(20),
ecity varchar(10),
esalary int
)
insert employee(ename,ejob,ecity,esalary)
values('Kemal','Manager','Istanbul','5000')
insert employee(ename,ejob,ecity,esalary)
values('Semih','Manager Assistant','Istanbul','4000')
insert employee(ename,ejob,ecity,esalary)
values('Mehmet','Software Engineer','Ankara','5500')
insert employee(ename,ejob,ecity,esalary)
values('Mert','Secreter','Ankara','1500')
insert employee(ename,ejob,ecity,esalary)
values('Melike','Secreter','Istanbul','2000')
insert employee(ename,ejob,ecity,esalary)
values('Ahmet','Software Engineer','Ankara','5500')
insert employee(ename,ejob,ecity,esalary)
values('Sezgin','Software Engineer','Istanbul','6500')
insert employee(ename,ejob,ecity,esalary)
values('Merve','Software Engineer','Istanbul','4500')
select * from employee
