Select the first and last names of all employees with either a 0 commission or no commission  reported (The commission value will be null if no commission is reported)

Select the first and last names of the employees hired between January 1, 1997 and December 31, 1997. Use BETWEEN

for Query Examples: Sample Database SalGrade Job SALG_GRADE SALG_LOSAL SALG HISAL JOB_TITLE SALG_GRADE Clerk 1 700 1200 Salesrep 2 1201 1400 Manager 4 3 1401 2000 Analyst 4 2001 3000 President 5 3001 9999 Department DEPT NO DEPT NAMEDEPT LOC 10 Accounting New York 20 Research Dallas 30 Sales Chicago 40 Operations Boston Employee EMP NO EMP FNAME EMP_LNAME EMP_STATUS EMP_SALARY EMP_COMM EMP HIREDATE EMP_MGR_EMP_NO Jo8 TITLE DEPT_NO 7839 Mark King active 5000 (null) 17-NOV-81 (null) Preaident 10 7839 Manager 7698 Jefferson Blake active 2850 (null) 01-MAY-91 30 Clark 7839 Manager 7782 Jamea active 2450 (nul1) 09-JUN-91 10 7839 Manager 7566 Mary Jones active 2975 (null) 02-APR-92 20 7566 Clerk Smith 7369 John active 800 (null) 28-SEP-94 20 7876 Joe 1100 Adams active (null) 20-FEB-94 7566 Clerk 20 7 (null) 08-SEP-91 7900 Jack James active 950 7698 Clerk 30 7934 Sue Miller 1300 (null) 03-DEC-95 7782 Clerk 10 active 7499 Steve Allen 1600 active 300 22-FEB-92 7698 Salesrep 30 10 7521 Tom Ward 7698 Salesrep 7698 Salesrep active 1250 500 03-DEC-97 30 dazsar 11 Turner 017-DEC-90 7844 Joe active 1500 30 .. 12 1400 09-DEC-97 7698 Salesrep 7654 Sandy Martin active 1250 30 13 7902 Robert Ford 3000 (null ) 12-JAN-95 7566 Analyst 20 active 14 7788 Michael Scott 3000 (null) 23-JAN-92 7566 Analyst active 20