what is email id of Mary | Did you mean what is the email of Mary or uid or her? | yes  user profiles email id of mary
SELECT email FROM user_profiles WHERE name  =  "Mary"
email id refers to email; user profiles email id of Mary refers to SELECT email FROM user_profiles WHERE name = 'Mary';