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?

Examine the following EMPLOYEES table: EMPLOYEES:EMPLOYEE_ID…

Examine the following EMPLOYEES table: EMPLOYEES:EMPLOYEE_ID NUMBER(9)LAST_NAME VARCHAR2(25)FIRST_NAME VARCHAR2(25)DEPARTMENT_ID NUMBER(9)SUPERVISOR_ID NUMBER(9) You need to produce a report that contains all employee-related information for those employees who have Brad Carter as a supervisor. However, you are not sure which supervisor ID belongs to Brad Carter. Which query should you issue to accomplish this task?

You need to delete a record in the EMPLOYEES table for Tim J…

You need to delete a record in the EMPLOYEES table for Tim Jones, whose unique employee identification number is 348. The EMPLOYEES table contains these columns:EMPLOYEE_ID NUMBER(5) PRIMARY KEYLAST_NAME VARCHAR2(20)FIRST_NAME VARCHAR2(20)ADDRESS VARCHAR2(30)PHONE NUMBER(10)Which DELETE statement will delete the appropriate record without deleting any additional records?

Below find the structure of the CUSTOMERS and SALES_ORDER ta…

Below find the structure of the CUSTOMERS and SALES_ORDER tables: CUSTOMERS:CUSTOMER_ID NUMBER NOT NULL, Primary KeyCUSTOMER_NAME VARCHAR2 (30) CONTACT_NAME VARCHAR2 (30)CONTACT_TITLE VARCHAR2 (20)ADDRESS VARCHAR2 (30)CITY VARCHAR2 (25)REGION VARCHAR2 (10)POSTAL_CODE VARCHAR2 (20)COUNTRY_ID NUMBER Foreign key to COUNTRY_ID column of the COUNTRY table PHONE VARCHAR2 (20)FAX VARCHAR2 (20) CREDIT_LIMIT NUMBER(7,2)SALES_ORDER:ORDER_ID NUMBER NOT NULL, Primary KeyCUSTOMER_ID NUMBER Foreign key to CUSTOMER_ID column of the CUSTOMER tableORDER_DT DATE ORDER_AMT NUMBER (7,2) SHIP_METHOD VARCHAR2 (5) You need to create a report that displays customers without a sales order. Which statement could you use?