Table: music_sales
Columns: region
date
label
format
catalog

Question: What's the region for an item on November 10, 2007 that's a cd?
SQL: SELECT "region" FROM music_sales WHERE "date" = 'november 10, 2007' AND "format" = 'cd'

Question: What's the catalog number for a record from columbia formatted in a cd/dvd that's from the United States region?
SQL: SELECT "catalog" FROM music_sales WHERE "label" = 'columbia' AND "region" = 'united states' AND "format" = 'cd/dvd'

Question: What's the catalog number for a December 11, 2007 record from columbia formatted in a that's from Canada?
SQL: SELECT "catalog" FROM music_sales WHERE "label" = 'columbia' AND "date" = 'december 11, 2007' AND "region" = 'canada'