Using AdventureWorks database or sample table data given below, write queries for below requirements: (Only query is required. Result of the query is not required)

Extract all person first name, middle and last name and their email where email_promotion is set to 1 and email contains only email domain as adventure- works.com and only those that were modified in May 2008 and after. Can you show the code and explin your answer. Thanks