The EMP table has these columns: Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）
1、The EMP table contains these columns:
The EMP table contains these columns:EMPLOYEE_ID NUMBER(4)EMPNAME VARCHAR2 (25)SALARY NUMBER(9,2)HIRE_DATE DATEYou query the database with this SQL ...
2、The EMP table contains these columns:
The EMP table contains these columns:LAST_NAME VARCHAR2 (25)SALARY NUMBER (6,2)DEPARTMENT_ID NUMBER (6)You need to display the employees who have ...
3、The EMP table contains these columns:
The EMP table contains these columns:You need to display the employees who have not been assigned to any department.You write the SELECT statem...
4、The EMPLOYEE tables has these columns
The EMPLOYEE tables has these columns:LAST_NAME VARCHAR2(35)SALARY NUMBER(8,2)COMMISSION_PCT NUMBER(5,2)You want to display the name and annual salar...
5、The EMPLOYEE tables has these columns
The EMPLOYEE tables has these columns:You want to display the name and annual salary multiplied by the commission_pct for all employees. For re...
6、The CUSTOMERS table has these columns
The CUSTOMERS table has these columns:CUSTOMER_ID NUMBER(4) NOT NULLCUSTOMER_NAME VARCHAR2(100) NOT NULLSTREET_ADDRESS VARCHAR2(150)CITY_ADDRESS VARCHAR...