Table: misfits_releases
Columns: year
artist
title
format
type

Question: Who was the artist before 2010 with a Promotional 7" as a format?
SQL: SELECT "artist" FROM misfits_releases WHERE "year" < 2010 AND "format" = 'promotional 7"'

Question: Who was the artist after 2012 with CD, LP as the format?
SQL: SELECT "artist" FROM misfits_releases WHERE "year" > 2012 AND "format" = 'cd, lp'

Question: What year had a title of Die Shaolin Affen EP and EP as the type?
SQL: SELECT AVG("year") FROM misfits_releases WHERE "type" = 'ep' AND "title" = 'die shaolin affen ep'

Question: What is the title of the Misfits with a CD format?
SQL: SELECT "title" FROM misfits_releases WHERE "format" = 'cd' AND "artist" = 'misfits'