PostgreSQL 15.6月度销售额及环比增长率（%）

weixin_sjt

已于 2024-03-27 13:51:29 修改

阅读量263

点赞数 6

分类专栏：数据库文章标签： postgresql

于 2024-03-27 11:30:56 首次发布

本文链接：https://blog.csdn.net/weixin_44505204/article/details/137072323

版权

数据库专栏收录该内容

4 篇文章 0 订阅

订阅专栏

在数据统计中我们经常会进行一些数据统计其中比较常见的就有环比增长率（例如我们想要计算每月营销金额的环比增长率（%）（本月销售金额-上月销售金额）/上月销售金额）*100

脚本准备

CREATE TABLE "orcl"."sales" (
"sale_id" int4 NOT NULL DEFAULT nextval('"orcl".sales_sale_id_seq'::regclass),
"sale_date" date NOT NULL,
"sale_amount" numeric(10,2) NOT NULL,
CONSTRAINT "sales_pkey" PRIMARY KEY ("sale_id")
)
;

ALTER TABLE "orcl"."sales"
OWNER TO "admin";

INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (1, '2017-04-23', '201.66');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (2, '2009-12-19', '441.13');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (3, '2010-07-08', '701.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (4, '2001-02-15', '751.47');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (5, '2005-09-14', '280.28');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (6, '2007-05-30', '712.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (7, '2020-04-29', '94.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (8, '2010-10-27', '360.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (9, '2023-07-18', '677.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (10, '2019-01-06', '164.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (11, '2011-06-01', '180.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (12, '2004-06-11', '48.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (13, '2014-03-16', '990.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (14, '2019-08-17', '367.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (15, '2023-04-20', '351.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (16, '2022-08-23', '483.09');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (17, '2010-07-28', '442.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (18, '2003-03-24', '597.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (19, '2016-09-28', '654.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (20, '2004-03-26', '861.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (21, '2008-05-05', '340.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (22, '2022-05-02', '691.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (23, '2008-11-22', '447.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (24, '2023-09-25', '151.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (25, '2017-08-19', '45.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (26, '2005-10-30', '787.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (27, '2016-05-25', '976.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (28, '2005-07-27', '420.21');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (29, '2010-05-03', '750.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (30, '2001-02-08', '266.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (31, '2007-05-03', '586.21');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (32, '2018-12-12', '331.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (33, '2021-04-30', '963.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (34, '2013-11-10', '424.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (35, '2005-01-24', '104.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (36, '2018-07-14', '877.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (37, '2022-05-23', '563.97');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (38, '2001-01-22', '845.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (39, '2023-08-03', '322.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (40, '2001-01-06', '698.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (41, '2013-08-25', '161.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (42, '2010-08-24', '690.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (43, '2003-05-21', '926.71');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (44, '2020-12-02', '534.26');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (45, '2011-03-26', '949.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (46, '2023-10-31', '74.80');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (47, '2001-07-23', '317.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (48, '2012-01-01', '276.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (49, '2022-05-16', '681.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (50, '2005-05-24', '296.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (51, '2010-01-23', '161.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (52, '2001-12-26', '4.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (53, '2010-11-19', '776.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (54, '2014-04-08', '388.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (55, '2008-12-11', '553.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (56, '2011-12-30', '222.85');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (57, '2023-01-09', '76.34');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (58, '2012-04-17', '219.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (59, '2000-09-19', '124.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (60, '2016-10-11', '930.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (61, '2018-05-04', '559.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (62, '2004-04-05', '932.66');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (63, '2018-05-24', '521.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (64, '2003-05-12', '235.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (65, '2015-05-31', '138.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (66, '2022-05-18', '140.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (67, '2004-05-24', '926.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (68, '2022-04-22', '996.67');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (69, '2004-11-05', '621.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (70, '2010-01-11', '443.28');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (71, '2011-11-04', '810.73');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (72, '2023-07-14', '931.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (73, '2009-09-20', '431.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (74, '2009-12-28', '769.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (75, '2012-07-17', '901.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (76, '2008-02-06', '980.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (77, '2013-04-04', '65.63');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (78, '2006-10-15', '232.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (79, '2005-06-11', '653.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (80, '2018-07-26', '411.47');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (81, '2000-05-27', '730.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (82, '2000-01-29', '851.47');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (83, '2000-09-20', '529.82');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (84, '2007-06-03', '277.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (85, '2006-07-09', '454.25');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (86, '2018-02-14', '516.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (87, '2015-12-17', '3.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (88, '2002-02-13', '43.13');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (89, '2007-06-11', '586.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (90, '2008-08-10', '883.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (91, '2008-10-05', '417.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (92, '2014-08-21', '640.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (93, '2006-06-26', '456.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (94, '2011-01-01', '335.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (95, '2012-07-26', '502.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (96, '2009-02-04', '575.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (97, '2024-02-17', '658.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (98, '2002-09-13', '882.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (99, '2011-01-12', '400.45');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (100, '2013-07-21', '325.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (101, '2020-12-02', '506.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (102, '2015-07-21', '73.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (103, '2018-05-06', '57.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (104, '2023-10-16', '847.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (105, '2009-07-27', '866.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (106, '2001-01-25', '185.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (107, '2022-02-19', '234.03');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (108, '2013-02-09', '641.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (109, '2022-07-08', '884.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (110, '2015-07-13', '46.26');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (111, '2002-01-14', '527.84');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (112, '2018-12-10', '695.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (113, '2020-07-01', '141.97');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (114, '2001-11-20', '266.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (115, '2006-10-22', '635.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (116, '2019-04-22', '466.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (117, '2003-11-26', '763.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (118, '2002-12-21', '169.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (119, '2017-09-12', '908.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (120, '2014-03-08', '418.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (121, '2015-03-04', '391.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (122, '2003-03-17', '59.02');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (123, '2010-11-01', '143.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (124, '2019-11-20', '242.44');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (125, '2005-01-13', '752.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (126, '2010-03-08', '407.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (127, '2003-11-11', '344.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (128, '2010-10-06', '526.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (129, '2012-12-27', '458.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (130, '2021-08-01', '430.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (131, '2015-11-07', '552.25');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (132, '2008-09-13', '386.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (133, '2023-03-11', '897.29');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (134, '2003-12-18', '14.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (135, '2014-07-19', '107.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (136, '2016-10-18', '932.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (137, '2011-09-05', '537.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (138, '2005-10-21', '222.80');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (139, '2010-09-04', '216.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (140, '2009-10-21', '198.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (141, '2023-07-09', '76.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (142, '2013-09-04', '262.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (143, '2004-02-19', '509.01');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (144, '2009-05-28', '109.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (145, '2012-11-16', '543.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (146, '2005-07-03', '781.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (147, '2017-12-19', '850.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (148, '2003-10-19', '168.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (149, '2019-08-06', '870.02');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (150, '2020-11-03', '939.18');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (151, '2021-11-11', '515.66');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (152, '2002-11-16', '217.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (153, '2009-07-06', '594.40');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (154, '2022-05-23', '871.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (155, '2009-08-05', '537.71');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (156, '2006-12-07', '459.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (157, '2005-09-28', '514.25');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (158, '2016-03-15', '253.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (159, '2008-11-10', '88.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (160, '2016-06-27', '506.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (161, '2022-10-17', '342.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (162, '2008-06-26', '336.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (163, '2021-12-20', '358.18');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (164, '2008-11-25', '313.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (165, '2001-01-02', '216.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (166, '2002-10-04', '556.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (167, '2019-08-22', '20.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (168, '2018-06-24', '539.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (169, '2011-09-16', '951.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (170, '2010-05-15', '290.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (171, '2009-09-26', '775.69');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (172, '2022-04-27', '673.03');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (173, '2020-01-08', '464.67');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (174, '2004-03-23', '547.47');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (175, '2007-05-27', '916.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (176, '2009-01-22', '69.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (177, '2001-11-19', '59.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (178, '2002-04-25', '980.47');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (179, '2020-06-20', '278.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (180, '2003-04-15', '914.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (181, '2012-05-22', '228.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (182, '2001-09-27', '322.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (183, '2017-04-30', '734.84');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (184, '2002-07-01', '696.26');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (185, '2006-05-15', '43.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (186, '2004-02-07', '653.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (187, '2013-07-19', '553.34');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (188, '2013-03-26', '943.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (189, '2016-07-08', '472.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (190, '2022-07-18', '576.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (191, '2020-12-19', '842.21');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (192, '2019-03-13', '598.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (193, '2006-05-02', '408.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (194, '2018-03-01', '824.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (195, '2018-04-27', '905.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (196, '2020-09-28', '372.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (197, '2010-03-09', '897.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (198, '2007-06-22', '101.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (199, '2017-06-16', '655.86');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (200, '2004-07-23', '763.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (201, '2000-09-06', '320.25');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (202, '2001-05-17', '15.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (203, '2023-07-01', '695.66');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (204, '2003-09-02', '676.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (205, '2015-08-01', '592.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (206, '2012-05-08', '474.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (207, '2012-01-12', '210.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (208, '2001-07-11', '992.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (209, '2005-10-21', '565.44');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (210, '2018-03-26', '236.18');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (211, '2001-03-13', '379.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (212, '2017-08-01', '600.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (213, '2003-01-16', '699.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (214, '2016-06-30', '667.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (215, '2014-06-17', '963.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (216, '2015-06-06', '542.25');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (217, '2023-03-09', '271.03');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (218, '2017-11-09', '988.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (219, '2013-10-02', '59.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (220, '2000-02-28', '417.69');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (221, '2000-06-03', '991.67');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (222, '2008-12-13', '719.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (223, '2009-02-13', '780.59');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (224, '2018-06-10', '139.34');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (225, '2017-10-10', '56.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (226, '2003-03-02', '204.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (227, '2006-11-23', '141.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (228, '2009-10-26', '962.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (229, '2010-10-24', '254.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (230, '2002-05-10', '380.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (231, '2009-01-16', '43.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (232, '2019-11-08', '637.29');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (233, '2022-06-29', '75.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (234, '2012-09-05', '717.38');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (235, '2012-07-14', '580.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (236, '2006-07-08', '145.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (237, '2000-02-17', '76.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (238, '2013-08-31', '80.66');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (239, '2008-07-30', '97.01');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (240, '2014-10-11', '555.24');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (241, '2001-03-14', '263.45');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (242, '2013-12-07', '694.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (243, '2011-07-08', '854.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (244, '2001-03-09', '515.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (245, '2007-08-23', '569.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (246, '2012-11-27', '171.29');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (247, '2002-04-07', '188.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (248, '2008-09-13', '75.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (249, '2015-02-11', '476.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (250, '2017-06-26', '248.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (251, '2015-01-31', '960.24');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (252, '2023-01-04', '643.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (253, '2008-01-13', '274.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (254, '2020-11-07', '389.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (255, '2000-04-22', '737.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (256, '2023-11-08', '379.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (257, '2023-02-04', '764.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (258, '2011-03-18', '265.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (259, '2022-08-02', '226.83');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (260, '2013-08-31', '656.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (261, '2015-11-04', '988.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (262, '2017-02-26', '783.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (263, '2004-07-16', '514.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (264, '2007-03-01', '544.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (265, '2000-03-14', '313.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (266, '2008-03-31', '747.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (267, '2005-02-07', '88.83');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (268, '2015-11-15', '979.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (269, '2016-04-16', '543.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (270, '2001-05-01', '802.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (271, '2003-07-25', '448.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (272, '2013-10-04', '575.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (273, '2013-06-09', '275.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (274, '2005-04-06', '337.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (275, '2005-12-29', '259.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (276, '2023-09-27', '474.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (277, '2018-10-10', '337.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (278, '2002-09-15', '504.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (279, '2011-11-14', '336.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (280, '2022-07-23', '151.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (281, '2002-09-07', '583.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (282, '2002-06-20', '691.34');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (283, '2016-10-28', '298.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (284, '2019-12-09', '669.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (285, '2009-08-23', '717.67');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (286, '2012-07-04', '616.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (287, '2012-08-26', '629.28');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (288, '2008-10-09', '240.21');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (289, '2008-11-17', '339.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (290, '2013-03-31', '843.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (291, '2015-03-14', '378.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (292, '2004-03-18', '973.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (293, '2009-03-31', '622.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (294, '2023-02-27', '854.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (295, '2020-10-06', '446.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (296, '2021-02-20', '987.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (297, '2020-02-11', '504.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (298, '2009-06-19', '261.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (299, '2018-09-20', '638.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (300, '2013-04-27', '37.73');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (301, '2023-07-30', '532.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (302, '2004-01-22', '425.09');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (303, '2013-07-07', '422.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (304, '2018-03-27', '309.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (305, '2015-03-28', '178.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (306, '2007-07-27', '448.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (307, '2014-12-25', '668.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (308, '2017-10-16', '737.26');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (309, '2020-10-17', '232.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (310, '2013-08-31', '439.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (311, '2008-12-12', '923.38');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (312, '2013-08-10', '458.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (313, '2012-02-05', '716.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (314, '2013-01-20', '690.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (315, '2001-08-11', '911.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (316, '2014-08-19', '419.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (317, '2023-07-09', '384.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (318, '2007-06-29', '958.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (319, '2009-02-10', '840.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (320, '2018-04-30', '879.59');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (321, '2008-05-04', '496.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (322, '2002-10-11', '559.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (323, '2014-05-05', '540.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (324, '2001-01-11', '161.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (325, '2006-02-09', '472.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (326, '2012-06-29', '882.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (327, '2018-08-09', '789.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (328, '2011-08-25', '840.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (329, '2022-08-30', '252.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (330, '2002-06-12', '41.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (331, '2004-07-11', '362.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (332, '2017-05-07', '201.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (333, '2006-07-06', '233.86');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (334, '2006-06-14', '905.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (335, '2021-03-14', '952.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (336, '2022-04-15', '754.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (337, '2023-08-21', '683.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (338, '2002-02-22', '279.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (339, '2005-05-26', '419.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (340, '2009-11-26', '433.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (341, '2022-02-04', '92.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (342, '2006-12-25', '884.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (343, '2017-02-22', '636.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (344, '2016-05-14', '23.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (345, '2023-05-20', '592.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (346, '2017-04-07', '375.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (347, '2004-09-02', '196.45');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (348, '2024-03-26', '317.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (349, '2006-09-16', '228.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (350, '2016-03-12', '426.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (351, '2011-01-24', '209.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (352, '2024-01-04', '66.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (353, '2008-07-25', '108.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (354, '2014-11-28', '480.34');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (355, '2023-04-29', '216.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (356, '2011-11-16', '384.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (357, '2019-08-16', '431.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (358, '2014-09-05', '57.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (359, '2011-02-25', '3.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (360, '2014-10-21', '253.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (361, '2006-08-29', '464.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (362, '2002-01-15', '228.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (363, '2013-12-09', '954.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (364, '2016-12-29', '287.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (365, '2008-01-01', '52.59');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (366, '2016-04-27', '999.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (367, '2023-09-23', '890.85');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (368, '2004-09-09', '450.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (369, '2009-08-21', '795.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (370, '2014-09-23', '265.64');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (371, '2011-10-06', '990.13');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (372, '2023-03-07', '853.47');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (373, '2017-11-05', '581.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (374, '2022-07-30', '437.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (375, '2007-04-20', '410.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (376, '2020-11-23', '36.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (377, '2020-06-07', '223.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (378, '2010-10-15', '50.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (379, '2007-07-17', '573.47');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (380, '2003-02-18', '109.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (381, '2003-09-25', '217.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (382, '2014-05-05', '872.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (383, '2013-04-15', '3.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (384, '2009-10-24', '23.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (385, '2000-12-29', '396.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (386, '2001-02-09', '555.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (387, '2015-06-25', '143.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (388, '2016-12-26', '50.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (389, '2001-11-19', '0.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (390, '2001-08-14', '613.13');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (391, '2015-09-12', '445.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (392, '2015-07-27', '345.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (393, '2005-10-07', '329.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (394, '2002-09-07', '982.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (395, '2003-03-17', '118.29');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (396, '2004-02-12', '80.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (397, '2013-01-12', '542.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (398, '2009-01-22', '999.59');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (399, '2006-01-21', '251.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (400, '2004-04-28', '786.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (401, '2008-04-18', '541.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (402, '2020-04-11', '562.63');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (403, '2015-07-18', '900.09');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (404, '2003-12-29', '926.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (405, '2012-11-14', '15.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (406, '2001-07-17', '858.63');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (407, '2002-05-19', '57.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (408, '2007-03-26', '764.85');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (409, '2002-09-05', '37.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (410, '2016-12-16', '485.84');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (411, '2021-10-16', '518.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (412, '2011-03-10', '250.63');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (413, '2001-01-18', '222.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (414, '2002-07-02', '749.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (415, '2020-04-06', '454.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (416, '2002-04-30', '34.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (417, '2015-11-08', '982.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (418, '2016-01-04', '118.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (419, '2013-05-18', '575.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (420, '2003-01-16', '454.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (421, '2018-04-17', '233.45');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (422, '2002-11-27', '674.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (423, '2003-09-05', '83.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (424, '2001-07-20', '396.21');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (425, '2003-08-17', '275.67');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (426, '2002-09-16', '182.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (427, '2009-02-01', '524.49');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (428, '2018-12-17', '337.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (429, '2005-04-28', '451.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (430, '2018-10-24', '771.64');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (431, '2007-01-10', '675.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (432, '2009-07-28', '652.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (433, '2006-04-26', '474.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (434, '2014-10-28', '206.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (435, '2015-02-01', '700.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (436, '2015-01-12', '302.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (437, '2023-04-20', '756.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (438, '2001-01-03', '557.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (439, '2019-10-10', '303.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (440, '2014-03-03', '879.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (441, '2001-01-15', '142.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (442, '2013-08-25', '383.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (443, '2021-03-18', '412.13');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (444, '2014-01-08', '110.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (445, '2005-12-03', '504.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (446, '2021-04-24', '455.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (447, '2014-09-06', '540.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (448, '2022-12-16', '627.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (449, '2002-01-07', '754.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (450, '2004-02-16', '484.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (451, '2021-09-21', '559.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (452, '2024-03-04', '93.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (453, '2004-11-10', '429.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (454, '2014-11-22', '426.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (455, '2010-01-01', '186.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (456, '2013-05-01', '749.97');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (457, '2022-03-08', '132.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (458, '2021-11-11', '723.01');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (459, '2005-05-14', '100.02');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (460, '2023-11-10', '766.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (461, '2023-03-03', '432.77');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (462, '2021-08-01', '128.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (463, '2018-12-05', '178.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (464, '2017-06-28', '117.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (465, '2024-01-06', '678.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (466, '2020-10-31', '74.69');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (467, '2008-08-18', '17.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (468, '2020-06-06', '12.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (469, '2006-08-18', '498.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (470, '2022-07-02', '532.25');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (471, '2014-12-21', '852.45');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (472, '2007-09-29', '435.66');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (473, '2007-01-12', '397.40');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (474, '2002-05-14', '404.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (475, '2006-10-09', '999.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (476, '2007-11-19', '786.09');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (477, '2012-01-07', '694.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (478, '2021-08-03', '862.73');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (479, '2006-11-25', '321.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (480, '2022-07-28', '265.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (481, '2012-09-05', '407.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (482, '2013-10-02', '36.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (483, '2011-11-06', '247.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (484, '2018-01-11', '94.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (485, '2014-10-15', '704.59');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (486, '2012-04-16', '0.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (487, '2010-06-01', '254.97');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (488, '2003-11-18', '758.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (489, '2012-11-01', '434.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (490, '2007-11-06', '442.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (491, '2004-04-30', '154.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (492, '2013-09-27', '582.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (493, '2011-06-02', '860.64');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (494, '2002-12-30', '170.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (495, '2009-09-14', '758.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (496, '2006-11-16', '505.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (497, '2003-12-31', '946.73');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (498, '2000-05-21', '651.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (499, '2000-04-09', '232.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (500, '2013-06-29', '81.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (501, '2016-08-10', '264.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (502, '2000-01-13', '995.28');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (503, '2003-01-14', '916.97');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (504, '2019-01-06', '100.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (505, '2006-03-16', '26.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (506, '2014-11-26', '809.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (507, '2023-10-02', '401.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (508, '2012-03-22', '942.67');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (509, '2014-10-14', '696.66');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (510, '2016-06-02', '887.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (511, '2003-05-29', '437.49');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (512, '2013-11-14', '206.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (513, '2010-01-21', '166.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (514, '2021-10-15', '102.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (515, '2007-11-22', '301.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (516, '2021-07-09', '169.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (517, '2002-11-04', '280.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (518, '2018-10-23', '214.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (519, '2023-09-14', '65.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (520, '2015-12-29', '723.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (521, '2019-12-15', '610.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (522, '2002-10-08', '219.24');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (523, '2010-07-27', '249.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (524, '2009-09-13', '272.28');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (525, '2009-06-14', '728.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (526, '2012-11-03', '427.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (527, '2007-05-20', '136.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (528, '2009-07-10', '120.40');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (529, '2002-04-14', '664.24');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (530, '2018-01-29', '988.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (531, '2017-12-16', '978.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (532, '2020-10-31', '183.97');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (533, '2011-01-18', '585.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (534, '2009-03-15', '449.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (535, '2002-03-30', '26.02');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (536, '2000-03-22', '832.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (537, '2014-10-07', '19.45');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (538, '2009-10-30', '773.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (539, '2022-01-18', '878.45');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (540, '2009-08-25', '77.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (541, '2000-06-20', '232.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (542, '2022-04-28', '460.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (543, '2003-12-11', '402.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (544, '2016-06-10', '637.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (545, '2000-08-17', '651.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (546, '2014-05-12', '108.77');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (547, '2002-01-01', '150.82');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (548, '2018-09-07', '301.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (549, '2015-07-28', '210.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (550, '2012-01-13', '960.24');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (551, '2005-02-15', '916.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (552, '2012-07-28', '7.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (553, '2016-03-22', '338.59');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (554, '2010-09-05', '504.80');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (555, '2011-05-16', '786.80');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (556, '2021-07-04', '672.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (557, '2000-04-21', '628.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (558, '2023-05-01', '869.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (559, '2010-09-20', '158.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (560, '2012-12-15', '981.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (561, '2013-08-24', '980.77');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (562, '2018-07-06', '504.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (563, '2008-04-03', '9.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (564, '2008-11-17', '652.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (565, '2008-04-29', '183.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (566, '2014-03-23', '76.40');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (567, '2010-04-20', '234.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (568, '2019-06-11', '221.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (569, '2000-12-30', '476.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (570, '2004-08-19', '817.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (571, '2022-05-20', '269.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (572, '2017-02-07', '203.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (573, '2011-04-25', '784.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (574, '2002-06-11', '758.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (575, '2022-09-10', '752.77');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (576, '2015-08-31', '982.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (577, '2012-01-01', '262.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (578, '2020-11-01', '919.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (579, '2013-07-31', '454.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (580, '2021-12-01', '166.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (581, '2010-07-29', '951.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (582, '2010-09-03', '988.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (583, '2018-06-01', '845.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (584, '2015-02-20', '456.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (585, '2016-11-16', '374.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (586, '2004-08-01', '816.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (587, '2022-03-27', '333.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (588, '2010-12-23', '849.09');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (589, '2007-08-22', '112.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (590, '2006-10-02', '241.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (591, '2022-12-26', '277.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (592, '2005-09-24', '923.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (593, '2005-07-01', '420.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (594, '2018-11-05', '62.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (595, '2004-06-16', '309.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (596, '2016-08-12', '126.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (597, '2013-04-02', '179.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (598, '2009-10-31', '711.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (599, '2002-10-31', '668.03');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (600, '2010-10-15', '235.73');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (601, '2020-03-18', '424.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (602, '2010-12-17', '837.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (603, '2012-03-05', '964.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (604, '2017-09-29', '309.80');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (605, '2012-08-27', '434.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (606, '2017-05-23', '68.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (607, '2007-08-02', '980.24');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (608, '2000-02-28', '998.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (609, '2023-01-13', '825.83');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (610, '2020-08-12', '147.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (611, '2010-12-19', '536.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (612, '2002-02-25', '137.24');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (613, '2009-07-22', '29.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (614, '2010-12-23', '405.44');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (615, '2005-05-30', '448.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (616, '2010-12-23', '288.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (617, '2009-06-03', '939.69');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (618, '2006-02-12', '237.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (619, '2014-11-20', '286.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (620, '2006-11-19', '67.84');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (621, '2008-12-25', '792.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (622, '2014-06-25', '667.84');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (623, '2005-03-25', '973.34');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (624, '2009-07-27', '139.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (625, '2012-08-15', '735.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (626, '2007-04-29', '215.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (627, '2015-03-26', '680.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (628, '2006-09-09', '877.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (629, '2009-08-24', '523.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (630, '2001-10-24', '74.09');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (631, '2013-01-31', '303.64');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (632, '2008-06-01', '874.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (633, '2024-01-27', '820.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (634, '2012-06-21', '68.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (635, '2021-01-06', '787.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (636, '2007-08-31', '182.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (637, '2021-07-28', '544.67');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (638, '2021-06-12', '64.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (639, '2020-08-19', '108.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (640, '2005-05-15', '312.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (641, '2023-07-03', '707.64');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (642, '2011-07-15', '790.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (643, '2004-04-04', '152.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (644, '2002-02-04', '134.26');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (645, '2019-08-26', '896.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (646, '2020-10-24', '518.83');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (647, '2007-09-28', '683.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (648, '2010-12-28', '400.77');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (649, '2022-07-11', '432.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (650, '2018-09-05', '593.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (651, '2005-05-01', '185.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (652, '2018-10-28', '160.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (653, '2001-08-06', '358.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (654, '2014-12-31', '358.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (655, '2003-06-24', '542.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (656, '2007-06-28', '784.29');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (657, '2013-02-17', '259.26');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (658, '2001-08-31', '589.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (659, '2016-02-26', '131.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (660, '2015-08-01', '859.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (661, '2003-03-25', '125.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (662, '2010-09-28', '622.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (663, '2015-11-13', '120.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (664, '2005-11-13', '929.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (665, '2018-09-27', '850.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (666, '2020-11-05', '999.86');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (667, '2010-02-25', '181.73');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (668, '2022-05-20', '554.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (669, '2010-12-31', '1.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (670, '2011-01-23', '18.80');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (671, '2015-03-18', '462.03');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (672, '2020-04-24', '870.68');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (673, '2006-05-20', '378.83');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (674, '2019-06-04', '216.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (675, '2003-04-02', '888.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (676, '2011-12-04', '427.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (677, '2007-04-02', '757.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (678, '2022-11-25', '558.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (679, '2015-04-01', '9.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (680, '2011-08-17', '505.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (681, '2024-03-07', '446.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (682, '2004-10-05', '233.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (683, '2008-11-17', '192.64');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (684, '2018-12-10', '474.69');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (685, '2019-08-19', '179.66');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (686, '2012-08-04', '150.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (687, '2011-11-21', '676.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (688, '2022-12-03', '117.25');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (689, '2010-11-05', '854.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (690, '2014-12-15', '322.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (691, '2009-05-30', '622.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (692, '2023-08-16', '416.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (693, '2009-03-05', '952.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (694, '2019-09-14', '804.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (695, '2008-01-16', '56.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (696, '2000-04-29', '231.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (697, '2011-08-11', '38.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (698, '2019-03-18', '559.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (699, '2004-05-22', '85.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (700, '2001-10-17', '609.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (701, '2010-10-15', '695.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (702, '2012-05-05', '816.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (703, '2022-12-16', '205.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (704, '2011-01-12', '497.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (705, '2010-11-18', '377.46');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (706, '2012-12-29', '116.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (707, '2022-02-05', '122.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (708, '2013-08-05', '7.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (709, '2018-05-06', '296.58');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (710, '2014-10-26', '531.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (711, '2020-02-09', '809.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (712, '2009-03-01', '614.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (713, '2009-01-22', '412.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (714, '2016-12-25', '58.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (715, '2000-03-01', '110.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (716, '2004-08-24', '312.25');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (717, '2013-07-25', '608.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (718, '2014-06-16', '204.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (719, '2004-06-24', '178.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (720, '2019-11-02', '232.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (721, '2010-05-15', '8.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (722, '2016-03-06', '741.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (723, '2012-05-17', '433.44');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (724, '2003-01-01', '23.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (725, '2003-10-01', '420.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (726, '2017-03-03', '901.86');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (727, '2022-11-20', '767.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (728, '2006-02-08', '966.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (729, '2013-03-15', '206.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (730, '2000-11-03', '339.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (731, '2006-07-24', '88.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (732, '2001-09-29', '201.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (733, '2003-07-26', '454.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (734, '2017-01-05', '757.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (735, '2016-02-27', '104.01');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (736, '2009-06-23', '864.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (737, '2007-06-03', '335.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (738, '2014-06-25', '324.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (739, '2020-01-19', '428.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (740, '2002-09-21', '61.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (741, '2003-06-17', '563.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (742, '2002-07-22', '872.02');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (743, '2016-01-05', '905.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (744, '2021-01-22', '554.01');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (745, '2020-11-13', '31.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (746, '2014-03-24', '140.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (747, '2020-03-14', '246.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (748, '2013-02-02', '525.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (749, '2019-03-07', '112.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (750, '2003-09-04', '854.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (751, '2001-02-18', '934.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (752, '2003-04-23', '151.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (753, '2021-03-21', '99.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (754, '2016-08-29', '963.85');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (755, '2002-05-19', '52.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (756, '2001-08-21', '997.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (757, '2007-05-10', '464.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (758, '2020-08-03', '675.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (759, '2015-09-14', '861.82');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (760, '2020-06-03', '806.77');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (761, '2004-08-21', '267.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (762, '2013-09-20', '503.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (763, '2008-09-06', '370.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (764, '2023-12-06', '366.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (765, '2021-03-18', '424.21');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (766, '2019-10-14', '176.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (767, '2007-04-28', '440.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (768, '2000-05-22', '817.65');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (769, '2003-09-16', '191.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (770, '2023-12-19', '198.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (771, '2016-10-11', '190.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (772, '2006-05-01', '998.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (773, '2014-03-20', '667.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (774, '2016-03-22', '261.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (775, '2020-04-28', '465.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (776, '2008-02-23', '523.71');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (777, '2011-08-12', '516.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (778, '2000-10-31', '401.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (779, '2009-07-18', '190.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (780, '2022-02-25', '423.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (781, '2022-11-14', '199.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (782, '2022-04-03', '827.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (783, '2010-06-18', '50.01');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (784, '2000-12-02', '929.05');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (785, '2023-11-09', '499.55');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (786, '2006-06-27', '716.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (787, '2019-04-20', '130.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (788, '2009-06-26', '352.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (789, '2017-04-12', '17.57');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (790, '2001-12-22', '125.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (791, '2021-08-01', '590.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (792, '2009-08-27', '244.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (793, '2015-07-28', '323.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (794, '2015-05-11', '606.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (795, '2014-10-03', '317.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (796, '2010-11-10', '3.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (797, '2000-03-06', '540.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (798, '2006-07-02', '830.14');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (799, '2012-05-24', '886.15');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (800, '2010-09-06', '931.31');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (801, '2022-08-10', '947.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (802, '2015-02-17', '421.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (803, '2020-09-17', '154.85');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (804, '2005-10-18', '690.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (805, '2004-01-06', '178.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (806, '2000-08-20', '690.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (807, '2009-07-23', '946.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (808, '2018-07-07', '970.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (809, '2002-09-15', '82.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (810, '2019-11-13', '367.18');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (811, '2020-01-17', '985.38');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (812, '2016-12-29', '413.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (813, '2019-11-05', '547.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (814, '2009-02-28', '14.28');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (815, '2019-03-17', '742.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (816, '2023-06-02', '299.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (817, '2023-06-23', '642.73');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (818, '2011-12-10', '478.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (819, '2024-03-12', '710.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (820, '2014-03-27', '437.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (821, '2012-04-07', '625.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (822, '2006-10-08', '690.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (823, '2015-09-21', '25.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (824, '2016-08-21', '425.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (825, '2006-09-05', '961.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (826, '2003-12-17', '909.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (827, '2023-01-20', '748.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (828, '2017-08-25', '609.13');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (829, '2009-03-07', '834.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (830, '2011-06-09', '154.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (831, '2015-05-20', '554.84');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (832, '2013-05-13', '13.77');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (833, '2007-10-19', '124.02');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (834, '2000-11-17', '851.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (835, '2003-02-08', '239.21');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (836, '2018-10-10', '360.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (837, '2010-10-04', '394.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (838, '2000-03-05', '23.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (839, '2003-05-05', '818.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (840, '2014-12-12', '362.13');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (841, '2019-09-19', '659.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (842, '2001-04-04', '839.54');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (843, '2009-02-08', '210.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (844, '2005-01-03', '172.62');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (845, '2003-10-26', '651.86');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (846, '2012-08-20', '374.83');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (847, '2006-07-02', '754.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (848, '2014-03-25', '264.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (849, '2013-04-06', '87.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (850, '2013-06-28', '56.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (851, '2003-08-30', '317.75');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (852, '2015-09-09', '475.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (853, '2010-10-25', '518.56');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (854, '2023-07-18', '725.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (855, '2008-04-30', '116.71');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (856, '2002-02-26', '120.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (857, '2005-06-19', '454.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (858, '2014-11-26', '314.17');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (859, '2011-08-11', '816.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (860, '2020-10-29', '142.49');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (861, '2014-08-24', '851.49');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (862, '2020-09-22', '66.98');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (863, '2008-02-17', '493.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (864, '2006-01-06', '883.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (865, '2004-02-02', '139.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (866, '2008-04-06', '155.74');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (867, '2019-03-05', '325.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (868, '2024-02-06', '894.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (869, '2016-09-23', '338.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (870, '2012-08-26', '880.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (871, '2013-04-13', '338.82');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (872, '2008-09-18', '366.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (873, '2023-12-16', '850.71');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (874, '2000-09-08', '43.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (875, '2004-06-13', '391.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (876, '2023-02-22', '248.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (877, '2012-01-04', '772.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (878, '2022-09-09', '76.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (879, '2001-02-26', '853.37');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (880, '2008-05-05', '816.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (881, '2004-05-11', '629.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (882, '2017-03-09', '949.59');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (883, '2022-02-02', '643.09');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (884, '2017-05-02', '197.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (885, '2018-12-18', '135.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (886, '2007-07-04', '315.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (887, '2022-02-13', '948.30');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (888, '2007-05-14', '127.51');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (889, '2006-12-14', '317.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (890, '2020-07-01', '360.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (891, '2018-10-16', '407.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (892, '2001-11-08', '295.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (893, '2000-05-07', '186.20');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (894, '2023-01-13', '619.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (895, '2023-01-23', '408.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (896, '2019-10-20', '794.85');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (897, '2020-11-23', '633.63');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (898, '2013-08-12', '725.86');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (899, '2019-06-13', '380.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (900, '2001-07-25', '120.86');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (901, '2003-10-18', '680.83');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (902, '2013-05-04', '215.93');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (903, '2007-08-07', '606.48');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (904, '2023-04-14', '252.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (905, '2020-08-02', '824.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (906, '2001-05-31', '572.29');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (907, '2016-09-25', '176.06');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (908, '2012-11-07', '332.49');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (909, '2018-08-20', '574.82');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (910, '2023-05-31', '860.53');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (911, '2007-10-06', '850.77');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (912, '2003-11-30', '709.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (913, '2023-12-12', '423.96');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (914, '2008-05-09', '49.11');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (915, '2024-02-10', '381.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (916, '2023-01-20', '360.22');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (917, '2011-06-14', '768.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (918, '2017-10-25', '640.35');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (919, '2001-07-09', '770.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (920, '2024-02-13', '913.44');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (921, '2002-12-21', '521.76');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (922, '2023-06-13', '703.85');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (923, '2005-06-11', '50.34');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (924, '2009-10-18', '283.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (925, '2021-03-29', '509.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (926, '2022-09-05', '906.60');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (927, '2018-12-22', '722.86');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (928, '2021-05-04', '29.64');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (929, '2001-10-25', '534.61');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (930, '2005-12-26', '623.26');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (931, '2013-11-13', '572.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (932, '2022-11-29', '561.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (933, '2002-08-04', '610.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (934, '2016-11-01', '685.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (935, '2017-03-06', '888.70');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (936, '2007-10-27', '912.94');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (937, '2023-09-12', '834.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (938, '2018-04-15', '573.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (939, '2007-05-26', '507.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (940, '2003-08-17', '745.99');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (941, '2000-09-06', '17.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (942, '2000-06-13', '903.72');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (943, '2016-12-20', '188.92');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (944, '2008-09-07', '425.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (945, '2012-02-21', '861.78');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (946, '2022-09-21', '577.84');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (947, '2005-01-22', '651.84');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (948, '2012-10-17', '395.87');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (949, '2005-08-11', '854.43');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (950, '2004-05-13', '374.08');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (951, '2016-02-01', '926.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (952, '2019-03-14', '423.79');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (953, '2013-02-27', '996.23');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (954, '2021-04-11', '555.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (955, '2021-06-17', '390.38');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (956, '2010-02-18', '238.80');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (957, '2005-03-04', '641.10');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (958, '2005-10-07', '680.81');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (959, '2017-03-07', '475.09');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (960, '2004-10-29', '429.03');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (961, '2023-01-06', '55.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (962, '2023-12-09', '694.88');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (963, '2018-01-30', '360.32');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (964, '2011-06-11', '141.04');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (965, '2016-03-25', '528.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (966, '2003-06-10', '418.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (967, '2015-04-23', '685.19');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (968, '2016-02-14', '501.41');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (969, '2023-05-20', '561.71');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (970, '2019-11-27', '554.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (971, '2015-07-18', '204.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (972, '2003-01-09', '831.90');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (973, '2002-04-21', '624.36');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (974, '2011-10-05', '388.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (975, '2006-10-23', '195.49');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (976, '2012-08-01', '619.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (977, '2014-12-04', '135.27');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (978, '2017-12-30', '310.50');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (979, '2016-11-13', '663.39');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (980, '2018-12-06', '217.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (981, '2020-01-17', '878.33');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (982, '2020-07-29', '915.91');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (983, '2002-05-09', '87.45');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (984, '2022-10-05', '765.00');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (985, '2024-02-24', '652.07');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (986, '2014-02-17', '651.52');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (987, '2004-01-09', '909.89');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (988, '2007-03-23', '542.16');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (989, '2000-05-19', '637.21');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (990, '2021-05-29', '959.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (991, '2004-10-25', '49.28');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (992, '2002-08-25', '426.95');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (993, '2006-06-13', '53.63');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (994, '2017-12-09', '619.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (995, '2007-10-11', '174.85');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (996, '2008-03-06', '399.42');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (997, '2014-04-30', '530.12');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (998, '2014-06-15', '24.28');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (999, '2014-07-14', '406.73');
INSERT INTO "orcl"."sales" ("sale_id", "sale_date", "sale_amount") VALUES (1000, '2013-05-08', '262.76');

sql

-- 计算月度销售额及环比增长率
WITH monthly_sales AS (
SELECT
date_trunc('month', sale_date) AS month_start,
SUM(sale_amount) AS amount,
LAG(SUM(sale_amount)) OVER (ORDER BY date_trunc('month', sale_date)) AS prev_amount
FROM
sales
GROUP BY
1
),
monthly_growth AS (
SELECT
month_start,
amount,
CASE
WHEN prev_amount IS NULL THEN NULL -- 首个月份无法计算环比
WHEN prev_amount = 0 THEN NULL -- 如果前一月销售额为0，则不计算增长率
ELSE ((amount - prev_amount) / prev_amount) * 100
END AS growth_rate
FROM
monthly_sales
)
SELECT
to_char(month_start, 'YYYY-MM') AS "year_month",
amount,
COALESCE(NULLIF(growth_rate, 0), 0) AS "环比增长率(%)"
FROM
monthly_growth;