You have to prepare a query to show the customer id and customer name in given database.
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.