Which of the following will return all the customers who have not been referred
ID: 3756436 • Letter: W
Question
Which of the following will return all the customers who have not been referred by other customers?
SELECT firstname, lastname
FROM customers
WHERE referred IS NULL;
SELECT firstname, lastname
FROM customers
WHERE referred LIKE 'N%';
SELECT firstname, lastname, customer#
FROM customers
WHERE customer# IS BLANK;
SELECT firstname, lastname, customer#
FROM customer
WHERE referred = '';
a.SELECT firstname, lastname
FROM customers
WHERE referred IS NULL;
b.SELECT firstname, lastname
FROM customers
WHERE referred LIKE 'N%';
c.SELECT firstname, lastname, customer#
FROM customers
WHERE customer# IS BLANK;
d.SELECT firstname, lastname, customer#
FROM customer
WHERE referred = '';
Explanation / Answer
here the answer would be
SELECT firstname, lastname --this will select firstname and lastname from the columns
FROM customers --from the customers table
WHERE referred IS NULL; -- this is the condition where the refered value in null
a.SELECT firstname, lastname --this will select firstname and lastname from the columns
FROM customers --from the customers table
WHERE referred IS NULL; -- this is the condition where the refered value in null
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.