Table: glasvegas_album
Columns: country
date
label
format
catalogue

Question: Which label is in a limited edition cd/dvd format?
SQL: SELECT "label" FROM glasvegas_album WHERE "format" = 'limited edition cd/dvd'

Question: What is the date for the United Kingdom with an LP format?
SQL: SELECT "date" FROM glasvegas_album WHERE "country" = 'united kingdom' AND "format" = 'lp'

Question: Which format is in Japan?
SQL: SELECT "format" FROM glasvegas_album WHERE "country" = 'japan'

Question: What is the format of catalog number 886973273913 (gowow012) in the United Kingdom?
SQL: SELECT "format" FROM glasvegas_album WHERE "country" = 'united kingdom' AND "catalogue" = '886973273913 (gowow012)'