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.

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