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?

The CUSTOMERS and SALES tables contain these columns: CUSTOM…

The CUSTOMERS and SALES tables contain these columns: CUSTOMERS:CUST_ID NUMBER(10) PRIMARY KEY COMPANY VARCHAR2(30) LOCATION VARCHAR2(20) SALES:SALES_ID NUMBER(5) PRIMARY KEY CUST_ID NUMBER(10) FOREIGN KEY TOTAL_SALES NUMBER(30) Which SELECT statement will return the customer ID, the company and the total sales?