error (see notes)
CREATE TABLE "top_10_singles" (
  "entered_a" text,
  "weeks_in_top_10" real,
  "single" text,
  "artist" text,
  "peak" real,
  "peak_reached_a" text,
  "weeks_at_number_1" real
);
SELECT MIN("weeks_at_number_1") FROM "top_10_singles";