Ruh this sql file :

DROP TABLE IF EXISTS EMP;

CREATE TABLE EMP (EMPNO DECIMAL(4), ENAME VARCHAR(10), JOB VARCHAR(9), MGR DECIMAL(4), HIREDATE DATE, SAL DECIMAL(7, 2), COMM DECIMAL(7, 2), DEPTNO DECIMAL(2));

INSERT INTO emp VALUES ('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20'); INSERT INTO emp VALUES ('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30'); INSERT INTO emp VALUES ('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30'); INSERT INTO emp VALUES ('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20'); INSERT INTO emp VALUES ('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30'); INSERT INTO emp VALUES ('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30'); INSERT INTO emp VALUES ('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10'); INSERT INTO emp VALUES ('7788','SCOTT','ANALYST','7566','1982-12-09','3000.00',NULL,'20'); INSERT INTO emp VALUES ('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10'); INSERT INTO emp VALUES ('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30'); INSERT INTO emp VALUES ('7876','ADAMS','CLERK','7788','1983-01-12','1100.00',NULL,'20'); INSERT INTO emp VALUES ('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30'); INSERT INTO emp VALUES ('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20'); INSERT INTO emp VALUES ('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');

DROP TABLE IF EXISTS DEPT;

CREATE TABLE DEPT (DEPTNO DECIMAL(2), DNAME VARCHAR(14), LOC VARCHAR(13) );

INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK'); INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS'); INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO'); INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON');

DROP TABLE IF EXISTS BONUS;

CREATE TABLE BONUS (ENAME VARCHAR(10), JOB VARCHAR(9), SAL DECIMAL, COMM DECIMAL);

DROP TABLE IF EXISTS SALGRADE;

CREATE TABLE SALGRADE (GRADE DECIMAL, LOSAL DECIMAL, HISAL DECIMAL);

INSERT INTO SALGRADE VALUES (1, 700, 1200); INSERT INTO SALGRADE VALUES (2, 1201, 1400); INSERT INTO SALGRADE VALUES (3, 1401, 2000); INSERT INTO SALGRADE VALUES (4, 2001, 3000); INSERT INTO SALGRADE VALUES (5, 3001, 9999);

Answer this questions with table on sql server.

-- 1. display name, department no and hire date of employees Example : SELECT ENAME , DEPTNO FROM EMP ; -- 2. display department numbers and locations -- 3. display name, salary and 10% increased salary of employees -- 4. display name and annual salary of employees -- 5. display name and annual salary of employees when we give 50 more for each month -- 6. display name and salary of employees including commission -- 7. display name, salary and annual salary of employees using aliases NAME, SALARY and YEARLY -- 8. display jobs without duplicates using emp table -- 9. display names of employees beginning with "A" -- 10. display names of employees with second character "A" -- 11. display jobs ending with "MAN" -- 12. display names and salaries of employees with increasing order of salaries -- 13. display name and job of employees in decreasing order of salaryies -- 14. Display names, jobs and salaries of employees which have salary between 2000 and 3000 -- 15. Display the name, job and salary for all employees whose salary is not equal to 1000, 3000, or 5000.