You have a database that tracks customer complaints. The database contains a table named Complaints that includes the following columns:

You have a database that tracks customer complaints. The database contains a table named Complaints that includes the following columns:

You need to create a query that lists complaints about defective products. The report must include complaints where the exact phrase “defective product” occurs, as well as complaints where similar phrases occur.

View Answer

Answer: D

Explanation:

References: https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-2017