Table: dude_ranch_album_sales
Columns: region
date
label
format
catalog

Question: What label is in CD format in Australia?
SQL: SELECT "label" FROM dude_ranch_album_sales WHERE "format" = 'cd' AND "region" = 'australia'

Question: What is the label for catalog number CRG3P-90054?
SQL: SELECT "label" FROM dude_ranch_album_sales WHERE "catalog" = 'crg3p-90054'

Question: What is the format for the MCA label?
SQL: SELECT "format" FROM dude_ranch_album_sales WHERE "label" = 'mca'

Question: What is the catalog number for the Grilled Cheese label?
SQL: SELECT "catalog" FROM dude_ranch_album_sales WHERE "label" = 'grilled cheese'

Question: Which region has the format CD and label MCA?
SQL: SELECT "region" FROM dude_ranch_album_sales WHERE "format" = 'cd' AND "label" = 'mca'

Question: What is the format for the label Mightier than Sword on January 12, 2010 in the United States?
SQL: SELECT "format" FROM dude_ranch_album_sales WHERE "region" = 'united states' AND "date" = 'january 12, 2010' AND "label" = 'mightier than sword'