DROP TABLE IF EXISTS `sales`;

CREATE TABLE `sales` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `date` varchar(255),
  `total` varchar(100) default NULL,
  `processed` varchar(255) default NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;

INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (100,"Jul 1, 2025","7.28","false"),
  (101,"Feb 25, 2024","39.20","false"),
  (102,"Jul 30, 2024","91.82","false"),
  (103,"Jul 12, 2025","3.07","true"),
  (104,"Oct 23, 2024","92.68","true"),
  (105,"Dec 17, 2025","85.79","false"),
  (106,"Sep 27, 2025","91.39","false"),
  (107,"Sep 7, 2025","34.73","true"),
  (108,"Mar 9, 2024","59.94","false"),
  (109,"Oct 6, 2024","31.83","true");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (110,"Feb 29, 2024","15.90","false"),
  (111,"May 23, 2025","87.43","false"),
  (112,"Nov 25, 2025","19.72","false"),
  (113,"Aug 7, 2025","70.05","true"),
  (114,"May 11, 2024","46.28","true"),
  (115,"Nov 2, 2025","57.64","false"),
  (116,"Jun 2, 2024","69.71","true"),
  (117,"Nov 3, 2024","63.38","true"),
  (118,"Nov 12, 2024","85.85","false"),
  (119,"Feb 21, 2025","83.95","true");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (120,"Jun 16, 2024","91.48","true"),
  (121,"May 9, 2025","63.07","true"),
  (122,"Sep 29, 2025","87.35","true"),
  (123,"Nov 20, 2025","4.55","true"),
  (124,"Feb 13, 2024","59.86","false"),
  (125,"Nov 26, 2024","32.35","true"),
  (126,"Jul 30, 2025","52.42","false"),
  (127,"Nov 23, 2025","0.67","true"),
  (128,"Nov 24, 2024","61.50","true"),
  (129,"May 4, 2025","61.13","false");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (130,"May 29, 2025","25.16","true"),
  (131,"Oct 5, 2024","37.60","false"),
  (132,"Jan 27, 2026","66.79","true"),
  (133,"Apr 3, 2025","10.64","true"),
  (134,"Aug 10, 2025","98.88","false"),
  (135,"Oct 14, 2025","35.37","false"),
  (136,"May 7, 2024","28.69","true"),
  (137,"Oct 25, 2024","97.73","true"),
  (138,"Sep 8, 2024","46.35","false"),
  (139,"Sep 26, 2024","71.37","true");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (140,"Oct 6, 2025","76.75","false"),
  (141,"Sep 9, 2024","95.57","true"),
  (142,"Jun 20, 2024","8.38","true"),
  (143,"Sep 27, 2025","35.34","true"),
  (144,"May 20, 2024","41.90","true"),
  (145,"Dec 23, 2024","84.54","true"),
  (146,"Jan 11, 2025","19.51","false"),
  (147,"Nov 23, 2025","22.35","false"),
  (148,"Jan 24, 2026","71.32","true"),
  (149,"Nov 20, 2025","88.94","false");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (150,"Sep 25, 2025","2.18","false"),
  (151,"Oct 12, 2024","36.61","false"),
  (152,"Jan 15, 2026","53.01","false"),
  (153,"Apr 17, 2025","57.24","true"),
  (154,"Apr 4, 2024","39.58","true"),
  (155,"Jun 7, 2025","12.39","false"),
  (156,"Mar 25, 2024","79.36","false"),
  (157,"Oct 7, 2024","90.35","true"),
  (158,"Jun 2, 2024","86.60","false"),
  (159,"Oct 2, 2024","53.18","true");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (160,"Oct 24, 2024","23.70","true"),
  (161,"Mar 11, 2025","95.67","true"),
  (162,"Jul 4, 2024","43.78","false"),
  (163,"Apr 7, 2024","45.33","true"),
  (164,"Jul 1, 2024","34.69","false"),
  (165,"Mar 10, 2025","6.44","false"),
  (166,"May 1, 2025","35.74","false"),
  (167,"Dec 14, 2025","94.13","false"),
  (168,"Oct 28, 2025","41.10","false"),
  (169,"Aug 28, 2024","58.45","false");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (170,"Dec 30, 2024","85.93","true"),
  (171,"Nov 10, 2024","44.64","false"),
  (172,"Dec 17, 2025","50.45","true"),
  (173,"Sep 9, 2025","91.66","false"),
  (174,"Mar 11, 2025","22.54","false"),
  (175,"Nov 23, 2024","63.69","true"),
  (176,"Mar 24, 2025","6.16","false"),
  (177,"Nov 27, 2024","66.23","true"),
  (178,"Nov 22, 2025","36.09","true"),
  (179,"Oct 16, 2025","7.74","true");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (180,"May 17, 2024","95.82","true"),
  (181,"Apr 21, 2025","55.40","false"),
  (182,"Sep 2, 2024","11.13","false"),
  (183,"Mar 28, 2025","32.46","true"),
  (184,"Dec 28, 2024","14.31","false"),
  (185,"Apr 18, 2024","71.85","true"),
  (186,"Jan 14, 2025","12.91","true"),
  (187,"Feb 16, 2025","8.99","false"),
  (188,"Jan 30, 2025","97.01","true"),
  (189,"Nov 6, 2024","57.86","true");
INSERT INTO `sales` (`id`,`date`,`total`,`processed`)
VALUES
  (190,"Sep 12, 2024","9.15","true"),
  (191,"Jul 25, 2024","30.98","false"),
  (192,"Jul 4, 2024","57.57","false"),
  (193,"Aug 27, 2025","65.04","true"),
  (194,"Jun 3, 2025","1.13","false"),
  (195,"May 21, 2024","21.21","false"),
  (196,"Nov 24, 2025","82.26","false"),
  (197,"Mar 14, 2025","47.17","true"),
  (198,"Sep 27, 2025","0.96","true"),
  (199,"Nov 16, 2025","34.64","false");

  -- Show what we've got 
  SELECT COUNT(*) AS number_of_false FROM sales WHERE processed = "false";

