MR12PLAY MR12PLAY - 9 months ago 30
SQL Question

Student/Newbie in need of help learning the basics

I am tasked with writing a few MySQL queries and I stuck. I must 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.

My previous statements queried fine but I am confused on how to achieve the above output. I am using two different tables and joining them. Previous statements was:

Select *
FROM ttms
Right JOIN country ON =
WHERE color = 'gold';

How do write the correct statement?


Take a look at this link,
Use the LIKE keyword to make your query, %wang% From

SELECT * FROM Customers
WHERE Country LIKE '%land%';