Which query identifies customers living in the same state as the customer named Leila Smith? a. SELECT customer# FROM customers WHERE state = (SELECT state FROM customers WHERE lastname = 'SMITH'); b....

Which query identifies customers living in the same state as the customer named

Leila Smith?

a. SELECT customer# FROM customers

WHERE state = (SELECT state FROM customers

WHERE lastname = 'SMITH');

b. SELECT customer# FROM customers

WHERE state = (SELECT state FROM customers

WHERE lastname = 'SMITH'

OR firstname = 'LEILA');

c. SELECT customer# FROM customers

WHERE state = (SELECT state FROM customers

WHERE lastname = 'SMITH'

AND firstname = 'LEILA'

ORDER BY customer);

d. SELECT customer# FROM customers

WHERE state = (SELECT state FROM customers

WHERE lastname = 'SMITH'

AND firstname = 'LEILA');