You have a table named Sales.PotentialClients. This table contains a column named EmailAddress. You are tasked to develop a report that returns valid ".com" email addresses from Sales.PotentialClients. A valid email address must have at least one character before the @ sign, and one character after the @ sign and before the ".com."
You need to write a Transact-SQL statement that returns data to meet the business requirements.
Which Transact-SQL statement should you use?
A. SELECT * FROM Sales.PotentialClients WHERE EmailAddress LIKE ‘_%@_.com’
B. SELECT * FROM Sales.PotentialClients WHERE EmailAddress LIKE ‘_%@_%.com’
C. SELECT * FROM Sales.PotentialClients WHERE EmailAddress LIKE ‘%@%.com’
D. SELECT* FROM Sales.PotentialClients WHERE EmailAddress LIKE ‘%@%[.]com
