What is the Canada singles in 1979 with a US A.C. of 24?
CREATE TABLE "singles" (
  "year" real,
  "song" text,
  "canada_singles" text,
  "us_hot_100" text,
  "us_a_c" text
);
SELECT "canada_singles" FROM "singles" WHERE "year"=1979 AND "us_a_c"='24';