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');