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

Question

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

Quizplus · Accepted Answer

Both A and B are correct because they both use a join to combine the data from the customers table (r) with the data from the customers table (c) based on the referred column. This allows us to display the first and last name of the individual who referred another customer, along with the customer# of the referred customer.

Structure of the CUSTOMERS Table