Answered! SQL – Write a query to show the athlete’s name and the name of their country but only for names that contain the…

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
Order Essay

Still stressed from student homework?
Get quality assistance from academic writers!