Question

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?
SELECT cust_id, company, total_sales
FROM customers c, sales s
WHERE c.cust_id = s.cust_id;
SELECT c.cust_id, c.company, s.total_sales
FROM customers c, sales s
WHERE c.cust_id = s.cust_id;
SELECT c.cust_id, c.company, s.total_sales
FROM customers c, sales s
WHERE c.cust_id = s.cust_id (+);
SELECT cust_id, company, total_sales
FROM customers, sales
WHERE cust_id = cust_id;

Answer 1

The correct SELECT statement to return the customer ID, the company, and the total sales is SELECT c.cust_id, c.company, s.total_sales FROM customers c, sales s WHERE c.cust_id = s.cust_id;

Step-by-step explanation:

The correct SELECT statement to return the customer ID, the company, and the total sales is SELECT c.cust_id, c.company, s.total_sales
FROM customers c, sales s
WHERE c.cust_id = s.cust_id;

This statement selects the cust_id and company columns from the customers table, and the total_sales column from the sales table. It then uses the WHERE clause to join the two tables based on the cust_id column.

By using the table aliases c and s, we can specify which table each column belongs to in the SELECT statement.