artist table:
 ID | NAME
 ---------------
  1 | ACDC
  2 | Weezer


song table:
 ID | NAME
 ---------------
  1 | Back in Black
  2 | Hells Bells
  3 | Big Balls
  4 | Island in the sun
  5 | My name is jones
  6 | Hash Pipe



tags table:
 artist | song
 ---------------
  1     |  1
  1     |  2
  1     |  3
  2     |  4
  2     |  5
  2     |  6


How can I query the DB songs table for a list of songs where the artist.name equals "ACDC"?