Table: sound_of_music_album
Columns: region
date
label
format
catalog

Question: What is Catalog, when the Region is UK, and when Label is Razor Records?
SQL: SELECT "catalog" FROM sound_of_music_album WHERE "region" = 'uk' AND "label" = 'razor records'

Question: What is the latest Date, when Label is Captain Oi! Records?
SQL: SELECT MAX("date") FROM sound_of_music_album WHERE "label" = 'captain oi! records'

Question: What is Region, when Date is 2004?
SQL: SELECT "region" FROM sound_of_music_album WHERE "date" = 2004

Question: What is Catalog, when Format is CD, when Region is US, when Date is before 2004, and when Label is Taang! Records?
SQL: SELECT "catalog" FROM sound_of_music_album WHERE "format" = 'cd' AND "region" = 'us' AND "date" < 2004 AND "label" = 'taang! records'