title: MySQL music database
body: <p>I am creating a MySQL database of music under Creative Commons. I am new to MySQL, however, so I am not sure if this is the correct setup, and if it is, how to query it.
  Here are my tables:</p>
  
  <pre><code> - `artist`
     - `id` - artist id
     - `name` - artist name
   - `genre`
     - ` id ` - genre id
     - ` name ` - genre name
   - `license`
     - `id` - license id
     - `name` - license name
   - `song`
     - `id` - song id
     - `artist ` - artist id
     - `title` - song title
     - `license ` - license id
     - `link` - link to song
   - `songgenre`
     - `genre` - genre id
     - `song` - song id
  </code></pre>
  
  <p>I would like it to give me this information:</p>
  
  <pre><code>------------------------------------------------
  |artist | song title| genre(s)| license | link |
  -----------------------------------------------
  </code></pre>
  
  <p>Any help is greatly appreciated.</p>
  
  <p>Edit: An example for the genres would be:</p>
  
  <pre><code>-------------------------
  | classical, orchestral |
  -------------------------
  </code></pre>
  
  <p>Basically a list of all genres the song falls under.</p>