Table: ccma_awards
Columns: year
location
fans_choice_award
male_artist_of_the_year
female_artist_of_the_year
group_or_duo_of_the_year

Question: Where did Carolyn Dawn Johnson win Female Artist of the Year, and Paul Brandt win Male Artist of the Year?
SQL: SELECT "location" FROM ccma_awards WHERE "female_artist_of_the_year" = 'carolyn dawn johnson' AND "male_artist_of_the_year" = 'paul brandt'

Question: Where did Doc Walker win Group or Duo of the Year, and where did Crystal Shawanda win Female Artist of the year?
SQL: SELECT "location" FROM ccma_awards WHERE "group_or_duo_of_the_year" = 'doc walker' AND "female_artist_of_the_year" = 'crystal shawanda'

Question: Who won Female Artist of the year in 1983, in the same city that Family Brown won Group of Duo of the year?
SQL: SELECT "female_artist_of_the_year" FROM ccma_awards WHERE "group_or_duo_of_the_year" = 'family brown' AND "year" = 1983