Structure of the CUSTOMERS Table

Multiple Choice

Structure of the CUSTOMERS table

-Which of the following queries will display the first and last name of the individual who referred another customer, along with the customer# of the referred customer?

A) SELECT r.firstname, r.lastname, c.customer# FROM customers r, customers c
WHERE r.customer# = c.referred;
B) SELECT r.firstname, r.lastname, c.customer# FROM customers r JOIN customers c
ON r.customer# = c.referred;
C) SELECT r.firstname, r.lastname, c.customer# FROM customers r NATURAL JOIN customers c;
D) both a and b