Which of the following lists only the last four digits of the contact person’s phone number at American Publishing?

a. SELECT EXTRACT (phone, -4, 1)

FROM publisher

WHERE name = 'AMERICAN PUBLISHING';

b. SELECT SUBSTR (phone, -4, 1)

FROM publisher

WHERE name = 'AMERICAN PUBLISHING';

c. SELECT EXTRACT (phone, -1, 4)

FROM publisher

WHERE name = 'AMERICAN PUBLISHING';

d. SELECT SUBSTR (phone, -4, 4)

FROM publisher

WHERE name = 'AMERICAN PUBLISHING';