Based on the code above,list the number,name,and complete address of every customer located on a street that contains the letters "Oxford".
A)SELECT CustomerNum,CustomerName,Street,City,State,Zip FROM Customer WHERE Street LIKE "?Oxford" ;
B)SELECT CustomerNum,CustomerName,Street,City,State,Zip FROM Customer WHERE Street LIKE "%Oxford%" ;
C)SELECT CustomerNum,CustomerName,Street,City,State,Zip FROM Customer WHERE Street LIKE "@Oxford@" ;
D)SELECT CustomerNum,CustomerName,Street,City,State,Zip FROM Customer WHERE Street LIKE "Oxford" ;

Question

Quizplus · Accepted Answer

The SQL wildcard "%" is used to match any sequence of characters. So in this case, "%Oxford%" will find any customer whose street contains the letters "Oxford" anywhere in the street name.

Based on the Code Above,list the Number,name,and Complete Address of Every