SQL Part 5 Create insert & Select

Query command & Data
CREATE TABLE emp
(
Id int PRIMARY key not null identity,
empno int,
empname varchar(200),
job varchar(200),
MGR int,
sal decimal,
comm decimal,
deptno int
)




INSERT INTO emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7876, 'Smith', 'clerk', 7788, 800, 0, 20);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7876, 'Adams', 'clerk', 7788, 1100, 0, 20);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7499, 'Allen', 'salesman', 7698, 1600, 300, 30);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7698, 'Blake', 'Manager', 7839, 2859, 0, 30);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7782, 'clark', 'Manager', 7839, 2459, 0, 10);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7902, 'Ford', 'Analyst', 7566, 3000, 0, 20);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7900, 'James', 'clerk', 7698, 950, 0, 30);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7566, 'Jones', 'manager', 7839, 2975, 0, 20);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7839, 'King', 'president', 0, 5000, 0, 10);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7839, 'Turner', 'salesman', 7698,1500, 0, 30);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7839, 'Adams', 'Clerk', 7788,1100, 0, 20);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7839, 'James', 'Clerk', 7698,950, 0, 30);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7839, 'Ford', 'Analyst', 7566,3000, 0, 20);
insert into emp (empno, empname, job, MGR, sal, comm, deptno)VALUES(7839, 'Miller', 'Clerk', 7782,1300, 0, 10)