Your department is responsible for creating a list of customer e-mail addresses from data in a SQL Server 2005 database. The list must include the date on which each customer was last contacted. The data in the result set must have column names. The list must be ordered by date of last contact, with the most recent contact first. The LastContact column is stored as a datetime. The date should be displayed as MM/DD/YYYY. A coworker develops the following query.
SELECT email_address AS EmailAddress, CONVERT(nvarchar, lastcontact, 101) AS LastContact FROM Contact ORDER BY LastContact DESC You test this query and find that the data is displayed in the following order.
EmailAddress LastContact [email protected] 01/24/2003
[email protected] 06/12/2005 [email protected] 07/13/2004
You need to modify the query so that the data is listed in the proper order. You want to achieve this goal without negatively affecting performance.
What should you do?
A.
Change the ORDER BY clause as follows:ORDER BY CONVERT(nvarchar, lastcontact, 101) DESC
B.
Remove the column alias from the LastContact column.
C.
Change the ORDER BY clause as follows:ORDER BY CAST(lastcontact AS nvarchar(20)) DESC
D.
Change the alias on the LastContact column.