What is Corey Peters Card_Number?
SELECT Card_Number FROM member where name = 'Corey Peters'
Corey Peters Card_Number refers to SELECT Card_Number; from a member with the name 'Corey Peters' refers to WHERE name = 'Corey Peters';