Please list the e-mail addresses of all the employees who wish to receive e-mail promotions from Adventureworks and selected partners.
employees who wish to receive e-mail promotions from AdventureWorks and selected partners refers to EmailPromotion = 2;
SELECT T2.EmailAddress FROM Person AS T1 INNER JOIN EmailAddress AS T2 ON T1.BusinessEntityID = T2.BusinessEntityID WHERE T1.EmailPromotion = 2