Lookup

Created by info@itofthefuture.com

Welcome Anonimous.User to this quiz related to SQL Query with wildcard characters and REPLACE function.

Read the question and choose the best answer. Time is limited to 40 seconds!

Important! Do not forget to rank the quality of the question (from bad to excellent).
An initiator of the quiz will get royalty score for QnAs created by her/him and can win the Top Creativity Prize.

Question:
Which query would display all the stockNames from the 'stocks' table where it will find all stocks with any of these three versions of "S&P" ( SandP, SNP, S&P )?

SELECT stockNames FROM [its].[dbo].[stocks]WHERE stockNames LIKE 'S_P%'

SELECT stockNames FROM [its].[dbo].[stocks]WHERE stockNames LIKE 'S%P'

SELECT stockNames FROM [its].[dbo].[stocks]WHERE stockNames LIKE 'S_P'

Rank the Quality of the Question from "-10" (bad) or "0" (not clear) to 10 (correct) or even 20 (very good!)
-10 (bad/wrong) 0 (not clear) 10 (correct) 20 (very good!)

Your summary report will be available to you and your instructor. Thank you for your work!!!