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.
Answer: D
Explanation:
References: https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-2017