A table named Contacts includes a column named SmtpAddress. You must develop a report that returns e-mail addresses from the Contacts table that have the following format: at least one character, the at sign (@), at least one character, and then ".org". You need to return data that meets the requirements.
Which Transact-SQL statement should you use?
A. select * from Contacts where SmtpAddress like ‘%@%.org’
B. select * from Contacts where SmtpAddress like ‘_%@_%.org’
C. select * from Contacts where SmtpAddress like ‘_%@_.org’
D. select * from Contacts where SmtpAddress like ‘%@%[.]org’