mysql> select song.title, artist.artist, genre.genre_name from song left join genre on song.genreid=genre.id left join artist on song.artistid=artist.id where artist.artist like "%pain%";
+------------------------------------------------------+---------------------------------------------+-------------+
| title                                                | artist                                      | genre_name  |
+------------------------------------------------------+---------------------------------------------+-------------+
| Jump Around                                          | house of pain                               | Rap         |
| I'm Sprung                                           | t-pain                                      | Hip-Hop     |
| Chopped & Screwed ft. Ludacris                       | t-pain                                      | Other       |
| I'm n' Luv wit a Stripper remix featuring mike jones | t-pain                                      | Hip-Hop/R&B |
| Bartender (Feat. Akon)                               | t-pain                                      | R&B         |
| Buy U A Drink ft. Young Joc                          | t-pain                                      | Other       |
| Cant Believe It Ft. Lil Wayne                        | t-pain                                      | Other       |
| I'm In Love With A Stripper (Remix)                  | t-pain                                      | Dance       |
| She Got It                                           | t pain                                      | Other       |
| Make Love To A Rap Song                              | t-pain feat. rick ross                      | Other       |
| Cutty Buddy                                          | mike jones ft. t-pain, twista, & lil' wayne | Other       |
| The Boss                                             | rick ross ft. t-pain                        | Hip-Hop     |
| Cutty Buddy Remix                                    | mike jones, t-pain, lil wayne & twista      | R&B         |
| I'm A Freak                                          | young cash feat. t-pain                     | Hip-Hop     |
+------------------------------------------------------+---------------------------------------------+-------------+
14 rows in set (0.10 sec)

mysql>