Question: Display the CustomerID, and customer's name (show the customer's name as the LastName concatenated to the FirstName separated by a comma and a space). Only demonstrate those customers that have the word/partial word "mail" somewhere in the EmailAddress. Order the results by the customer's last name in ascending order.
Please provide a detailed answer so that I will learn from it. Thank you!