EMP Table to learn SQL

EMPTable

Table Name: EMP
Columns: 

EMPNO     [numeric](4, 0) NOT NULL PRIMARY KEY,
ENAME     [varchar](10) NULL,
JOB       [varchar](10) NULL,
MGR       [numeric](4, 0) NULL,
HIREDATE  [date] NULL,
SAL       [numeric](7, 2) NULL,
COMM      [numeric](7, 2) NULL,
DEPTNO    [numeric](2, 0) NULL

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