Show all the names of the song.
select song_name from song
How many of them contain the word 'robe'?
select count(*) from song where song_name like "%robe%"
How about the word 'love'?
select count(*) from song where song_name like "%love%"
What are the name and country of origin for the artists of these songs?
select t1.artist_name, t1.country from artist as t1 join song as t2 on t1.artist_name = t2.artist_name where t2.song_name like "%love%"