text: # --- !Ups
  
  CREATE TABLE "sales" ("sale_id" BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 1000) NOT NULL PRIMARY KEY, "sale_date" DATE NOT NULL);
  CREATE INDEX "idx_sale" ON "sales"("sale_id", "sale_date");
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-01');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-01');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-02');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-02');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-02');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-02');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-03');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-03');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-03');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-03');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-03');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-03');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-04');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-04');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-05');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-05');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-05');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-06');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-06');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-06');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-06');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-06');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-07');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-07');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-07');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-08');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-09');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-10');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-11');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-12');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-13');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-13');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-14');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-14');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-14');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-14');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-15');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-21');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-22');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-25');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-26');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-27');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-27');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-27');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-01-28');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-01');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-02');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-03');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-04');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-05');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-06');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-07');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-07');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-07');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-08');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-09');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-10');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-11');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-12');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-13');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-13');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-14');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-14');
  INSERT INTO "sales" ("sale_date") VALUES ('2022-02-14');
  # --- !Downs
  
  DROP TABLE "sales"