The EMPLOYEES and ORDERS tables contain these columns: EMPLO…
The EMPLOYEES and ORDERS tables contain these columns: EMPLOYEES:EMPLOYEE_ID NUMBER(10) NOT NULL PRIMARY KEY FIRST_NAME VARCHAR2(30)LAST_NAME VARCHAR2(30)ADDRESS VARCHAR2(25)CITY VARCHAR2(20)STATE VARCHAR2(2) ZIP NUMBER(9)TELEPHONE NUMBER(10) ORDERS:ORDER_ID NUMBER(10) NOT NULL PRIMARY KEY EMPLOYEE_ID NUMBER(10) NOT NULL FOREIGN KEYORDER_DATE DATETOTAL NUMBER(10) Which SELECT statement will return all orders generated by a sales representative named Franklin during the year 2001?