This query is meant to answer the Provide a list of all orders that have “skate board” in their description. However, it seems to miss a number of orders. Your job is to debug the query and make it work correctly. There are two problems with the query:
SELECT CustomerName, OrderDate, PurchaseOrder, ProductName FROM Sales WHERE ProductDescription LIKE ‘Skate Board%’;
【General guidance】The answer provided below has been developed in a clear step by step manner.Step1/3There are issues with the supplied SQL query that may cause it to miss some commands with "skateboard" in their description. Here are some possible solutions:Explanation:Please refer to solution in this step.Step2/31.Case Sensitive: The query searches for "Skate Board%" with a capital "S", which means it will only match descriptions beginning with "Skate Board" with a capital "S". If there is a description starting with "skateboard" with a lowercase "s", it will be ignored. To solve this problem, you can use the "LOWER()" function to convert the description to lowercase before searching for "skate board":SELECT Customer ... See the full answer