SQL – Write a query to show the athlete’s name and the name of their country but only for names that contain the string ‘wang’ anywhere in the name.
Expert Answer
Select name,country from Athletes where name like ‘%wang%’;
% is wildcard character for 0,1 or more characters . Here the query returns the names of athletes which contain the string wang.
Don't use plagiarized sources. Get Your Custom Essay on
Answered! SQL – Write a query to show the athlete’s name and the name of their country but only for names that contain the…
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE