Link: https://www.meetgor.com/logsql/sqlite-functions-unistr-and-unistr-quote/
or.com/logsql/sqlite-dot-commands-html-tables-with-output-and-once/" rel=“nofollow ugc noopener”>Once dot command with html tables
Source: techstructive-weekly-57
Some weeks are no for hoarding knowledge, I realize this after writing this edition. And this week is that one, the one that you need to put breaks and not reflect that’s done, but see the road ahead, not how far we have come, but where to go next. What to do next, why build something, why spent 2 years on something. Question, think, understand and let it settle. Everyone is doing that. Some aren’t privileged as I am, I am grateful for that.
Link: https://atlas9.dev/blog/soft-delete.html
Nice read. I had experienced it in my first internship. This problem of dead objects. Especially if you are using Django and Postgres. It looked easy to add a field of soft deletion. But the resulting queries could create bottlenecks. Since then I haven’t quite gotten the chance to explore this, this article showed me the different ways to implement the soft deletion.
Oh the middle of end of 2025, and the beginning of 2026. This is a wired post. I let myself back, reflected more. I know it was a fast paced year for software development. People are here to prove it. I just laid it out straight that its never been valuable to be a human, a distinct, natural and earnest human.
We are on the final day of Advent of SQL!
I can’t believe it, I completed it! (with some help of course, I don’t didn’t know SQL very well. But this 15 days flipped it around.). I feel good and fresh to start the year to go deep in SQLite and databases!
Let’s solve the last day first, if it has somethings reamining to teach us!
Ok, almost to the penultimate day in the series. It is day 14 of Advent of SQL.
Let’s grab the SQL for the day.
DROP TABLE IF EXISTS mountain_network;
CREATE TABLE mountain_network (
id INTEGER PRIMARY KEY,
from_node TEXT,
to_node TEXT,
node_type TEXT, -- 'Lift' or 'Trail'
difficulty TEXT -- Only applicable for trails: 'green', 'blue', 'black', 'double_black'
);
INSERT INTO mountain_network (id, from_node, to_node, node_type, difficulty) VALUES
(1, 'Outlaw Express', 'Stairway Lift', 'Lift', NULL),
(2, 'Outlaw Express', 'Top Gun Bowl', 'Trail', 'black'),
(3, 'Top Gun Bowl', 'Top Gun', 'Trail', 'black'),
(4, 'Top Gun', 'Montoya', 'Trail', 'blue'),
(5, 'Montoya', 'Center Aisle', 'Trail', 'green'),
(6, 'Center Aisle', 'Lower Stampede', 'Trail', 'green'),
(7, 'Stairway Lift', 'Red''s Lift', 'Lift', NULL),
(8, 'Stairway Lift', 'Broadway', 'Trail', 'green'),
(9, 'Red''s Lift', 'Bearclaw', 'Trail', 'blue'),
(10, 'Bearclaw', 'Last Chance', 'Trail', 'blue'),
(11, 'Last Chance', 'Diamondback', 'Trail', 'blue'),
(12, 'Diamondback', 'Broadway', 'Trail', 'green'),
(13, 'Red''s Lift', 'Bishop''s Bowl', 'Trail', 'black'),
(14, 'Red''s Lift', 'Amy''s Ridge', 'Trail', 'blue'),
(15, 'Amy''s Ridge', 'Grizzly Bowl', 'Trail', 'black'),
(16, 'Flathead Lift', 'Amy''s Ridge', 'Trail', 'blue'),
(17, 'Jake''s Lift', 'Wildwood Lift', 'Lift', NULL),
(18, 'Wildwood Lift', 'Sidewinder', 'Trail', 'green'),
(19, 'Wildwood Lift', 'Brightside', 'Trail', 'blue'),
(20, 'Brightside', 'Moonrise', 'Trail', 'green'),
(21, 'Moonrise', 'Draw', 'Trail', 'green'),
(22, 'Moonrise', 'Lone Pine', 'Trail', 'blue'),
(23, 'Draw', 'Maverick', 'Trail', 'blue'),
(24, 'Draw', 'Broadway', 'Trail', 'green'),
(25, 'Broadway', 'Outlaw Trail', 'Trail', 'green'),
(26, 'Outlaw Trail', 'Center Aisle', 'Trail', 'green'),
(27, 'Center Aisle', 'Bandit', 'Trail', 'green'),
(28, 'Jake''s Lift', 'Maverick', 'Trail', 'blue');
That’s it, we just have 1 table called mountain_network and it has 28 records.
Its day 13 of Advent of SQL, we have some xml to parse, which I don’t think SQL can handle, but string manipulation to the rescue.
Let’s get the SQL for the day:
DROP TABLE IF EXISTS travel_manifests;
CREATE TABLE travel_manifests (
manifest_id INT PRIMARY KEY,
vehicle_id TEXT,
departure_time TIMESTAMP,
manifest_xml XML
);
INSERT INTO travel_manifests (manifest_id, vehicle_id, departure_time, manifest_xml) VALUES
(1, 'SLEIGH-01', '2025-12-22 06:00:00', '<manifest><passengers><passenger><name>Nia Grant</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Sofia Kim</name><ticket_class>overnight</ticket_class><engine_check>ignored</engine_check></passenger><passenger><name>Jonah Wolfe</name><ticket_class>standard</ticket_class><snack_inventory>ignored</snack_inventory></passenger></passengers></manifest>'),
(2, 'SLEIGH-07', '2025-12-23 13:00:00', '<manifest><passengers><passenger><name>Ravi Patel</name><ticket_class>priority</ticket_class></passenger><passenger><name>Keiko Ito</name><ticket_class>standard</ticket_class></passenger><passenger><name>Anya Pavlov</name><ticket_class>standard</ticket_class></passenger><passenger><name>Nia Grant</name><ticket_class>priority</ticket_class><snack_inventory>ignored</snack_inventory></passenger><passenger><name>Carter Lewis</name><ticket_class>priority</ticket_class><engine_check>ignored</engine_check></passenger><passenger><name>Layla Brooks</name><ticket_class>standard</ticket_class><reindeer_mood>ignored</reindeer_mood></passenger></passengers></manifest>'),
(3, 'FLIGHT-NP-9', '2025-12-22 18:00:00', '<manifest><passengers><passenger><name>Keiko Ito</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Jonah Wolfe</name><ticket_class>priority</ticket_class></passenger><passenger><name>Diego Ramos</name><ticket_class>overnight</ticket_class><snack_inventory>ignored</snack_inventory></passenger><passenger><name>Priya Das</name><ticket_class>priority</ticket_class></passenger><passenger><name>Layla Brooks</name><ticket_class>standard</ticket_class></passenger></passengers></manifest>'),
(4, 'TRAIN-ICE-3', '2025-12-22 18:00:00', '<manifest><reindeer_mood>low</reindeer_mood><passengers><passenger><name>Isla Torres</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Ravi Patel</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Hiro Tanaka</name><ticket_class>standard</ticket_class></passenger><passenger><name>Priya Das</name><ticket_class>priority</ticket_class></passenger></passengers></manifest>'),
(5, 'FLIGHT-NP-9', '2025-12-22 17:00:00', '<manifest><passengers><passenger><name>Nia Grant</name><ticket_class>priority</ticket_class></passenger><passenger><name>Mateo Cruz</name><ticket_class>standard</ticket_class><snowfall_inches>ignored</snowfall_inches></passenger></passengers></manifest>'),
(6, 'CARGO-12', '2025-12-22 15:00:00', '<manifest><passengers><passenger><name>Carter Lewis</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Sofia Kim</name><ticket_class>priority</ticket_class></passenger><passenger><name>Hiro Tanaka</name><ticket_class>priority</ticket_class></passenger><passenger><name>Lucas Ford</name><ticket_class>priority</ticket_class><snack_inventory>ignored</snack_inventory></passenger><passenger><name>Nia Grant</name><ticket_class>overnight</ticket_class></passenger></passengers></manifest>'),
(7, 'SLEIGH-01', '2025-12-22 11:00:00', '<manifest><snack_inventory>unknown</snack_inventory><passengers><passenger><name>Priya Das</name><ticket_class>standard</ticket_class></passenger><passenger><name>Diego Ramos</name><ticket_class>standard</ticket_class></passenger><passenger><name>Lucas Ford</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Carter Lewis</name><ticket_class>overnight</ticket_class><reindeer_mood>ignored</reindeer_mood></passenger><passenger><name>Hiro Tanaka</name><ticket_class>priority</ticket_class><weather_note>ignored</weather_note></passenger><passenger><name>Zara Sheikh</name><ticket_class>overnight</ticket_class></passenger></passengers></manifest>'),
(8, 'CARGO-12', '2025-12-23 13:00:00', '<manifest><passengers><passenger><name>Jonah Wolfe</name><ticket_class>standard</ticket_class></passenger><passenger><name>Layla Brooks</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Leo Becker</name><ticket_class>overnight</ticket_class><weather_note>ignored</weather_note></passenger><passenger><name>Ravi Patel</name><ticket_class>standard</ticket_class></passenger><passenger><name>Sofia Kim</name><ticket_class>priority</ticket_class><snack_inventory>ignored</snack_inventory></passenger><passenger><name>Elena Morales</name><ticket_class>overnight</ticket_class></passenger></passengers></manifest>'),
(9, 'SLEIGH-01', '2025-12-23 10:00:00', '<manifest><passengers><passenger><name>Sofia Kim</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Bianca Pereira</name><ticket_class>standard</ticket_class></passenger><passenger><name>Zara Sheikh</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Elena Morales</name><ticket_class>overnight</ticket_class><reindeer_mood>ignored</reindeer_mood></passenger><passenger><name>Hiro Tanaka</name><ticket_class>priority</ticket_class></passenger><passenger><name>Keiko Ito</name><ticket_class>priority</ticket_class><snack_inventory>ignored</snack_inventory></passenger></passengers></manifest>'),
(10, 'SLEIGH-01', '2025-12-22 21:00:00', '<manifest><snowfall_inches>low</snowfall_inches><passengers><passenger><name>Nia Grant</name><ticket_class>standard</ticket_class></passenger><passenger><name>Ava Johnson</name><ticket_class>standard</ticket_class></passenger><passenger><name>Priya Das</name><ticket_class>priority</ticket_class></passenger><passenger><name>Mateo Cruz</name><ticket_class>standard</ticket_class></passenger><passenger><name>Bianca Pereira</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Leo Becker</name><ticket_class>overnight</ticket_class></passenger></passengers></manifest>'),
(11, 'SLEIGH-07', '2025-12-23 10:00:00', '<manifest><passengers><passenger><name>Jonah Wolfe</name><ticket_class>priority</ticket_class></passenger><passenger><name>Bianca Pereira</name><ticket_class>priority</ticket_class></passenger><passenger><name>Anya Pavlov</name><ticket_class>standard</ticket_class></passenger></passengers></manifest>'),
(12, 'SLEIGH-01', '2025-12-22 08:00:00', '<manifest><reindeer_mood>ok</reindeer_mood><passengers><passenger><name>Ravi Patel</name><ticket_class>priority</ticket_class><snack_inventory>ignored</snack_inventory></passenger><passenger><name>Bianca Pereira</name><ticket_class>priority</ticket_class></passenger><passenger><name>Keiko Ito</name><ticket_class>standard</ticket_class></passenger></passengers></manifest>'),
(13, 'FLIGHT-NP-9', '2025-12-22 11:00:00', '<manifest><snowfall_inches>ok</snowfall_inches><passengers><passenger><name>Nia Grant</name><ticket_class>priority</ticket_class></passenger><passenger><name>Elena Morales</name><ticket_class>standard</ticket_class></passenger></passengers></manifest>'),
(14, 'SLEIGH-01', '2025-12-22 14:00:00', '<manifest><engine_check>high</engine_check><passengers><passenger><name>Layla Brooks</name><ticket_class>standard</ticket_class><weather_note>ignored</weather_note></passenger><passenger><name>Anya Pavlov</name><ticket_class>overnight</ticket_class></passenger><passenger><name>Keiko Ito</name><ticket_class>standard</ticket_class></passenger><passenger><name>Zara Sheikh</name><ticket_class>standard</ticket_class><engine_check>ignored</engine_check></passenger><passenger><name>Sofia Kim</name><ticket_class>overnight</ticket_class></passenger></passengers></manifest>'),
(15, 'FLIGHT-NP-9', '2025-12-22 14:00:00', '<manifest><snowfall_inches>ok</snowfall_inches><passengers><passenger><name>Priya Das</name><ticket_class>priority</ticket_class><snowfall_inches>ignored</snowfall_inches></passenger><passenger><name>Bianca Pereira</name><ticket_class>standard</ticket_class></passenger><passenger><name>Nia Grant</name><ticket_class>standard</ticket_class></passenger></passengers></manifest>');
Just one table, with some wild XML.
We are on Day 12! Phew its almost done! Just 3 days more!
Let’s get the SQL!
DROP TABLE IF EXISTS archive_records;
CREATE TABLE archive_records (
id INT PRIMARY KEY,
title TEXT,
description TEXT
);
INSERT INTO archive_records (id, title, description) VALUES
(1, 'Flight Stabilization Prototype Analysis', 'This report details the latest advancements in stabilizing aerial maneuvers for enchanted sleighs. Initial tests yielded promising results, showcasing a marked decrease in turbulence during airborne navigation.'),
(2, 'Lift Calibration Incident Log', 'During a routine lift calibration test, the sleigh experienced an unexpected upward surge, causing it to hover dangerously close to the workshop ceiling. Subsequent analysis revealed a miscalculation in the weight distribution formula, prompting a thorough review of all aerodynamic coefficients.'),
(3, 'Aerial Aspirations: The Great Flop', 'Despite the initial excitement surrounding the design of our feather-laden airborne contraption, the prototype proved less than buoyant. The unexpected descent resulted in a rather spectacular cloud of glitter and twigs, serving as a vivid reminder that not all dreams of flight take wing as intended.'),
(4, 'Optimized Sled Dynamics', 'This document explores advanced mechanics behind sled propulsion and movement efficiency. Through extensive calculations and enchanted material tests, the elves aim to refine turning capabilities and enhance downhill speed.'),
(5, 'Reindeer Harness Design Flaws', 'The latest prototype of our reindeer harness was found to inhibit mobility, causing undue strain on the animals during testing. Observations indicated that the weight distribution was poorly calibrated, necessitating a complete redesign for optimal comfort and performance.'),
(6, 'Streamlined Cargo Routing System', 'In our latest endeavor, we have implemented a magical algorithm to optimize the route taken by our toy-laden sleighs. This groundbreaking update minimizes transport time between the workshop and delivery points, ensuring that holiday cheer reaches every home even faster!'),
(7, 'Toy Durability Testing Protocols', 'The elves meticulously conducted stress evaluations on the latest toy prototypes to determine their resilience under various conditions. Initial findings indicate that while some designs withstood rigorous play, others required reinforcements to avoid premature wear and tear.'),
(8, 'Weather Resistance Breakthrough: Frost Shielding', 'In our recent experiments, we discovered an innovative composite material that effectively repels moisture while withstanding extreme cold. This newfound frost shielding could revolutionize our outdoor toys, ensuring they remain both functional and enchanting, even in the harshest winter conditions.'),
(9, 'Safety Compliance Check Overview', 'In the pursuit of enchantment and joy, this document outlines the mandatory safety compliance measures for all workshop operations. Each elf must adhere strictly to these guidelines to ensure the safe transport and handling of our delicate prototypes, thus preventing any unforeseen magical mishaps.'),
(10, 'Sleigh Skim Mechanism Upgrade', 'The experiment involved enchanting the underside of the sleigh with a whispering wind charm to achieve unprecedented speeds. Results were alarming, leading to uncontrollable flight trajectories and sudden descents—definitely do not attempt again.'),
(11, 'Caution: Enchanted Toy Prototype', 'This design incorporates a reactive magic component that may unpredictably animate in the presence of mischief. Ensure all test environments are secured against spontaneous giggles and potential chaos.'),
(12, 'Workshop Experiment Safety Checklist', 'Before embarking on any workshop experiments, ensure all safety goggles are securely fastened to prevent debris from interfered visions. Always double-check that the workspace is free of clutter, as unexpected accidents can arise from even the smallest flurry of trinkets and tools.'),
(13, 'Cocoa Bean Roasting Innovations', 'This review explores the latest techniques in roasting cocoa beans to achieve unparalleled flavor profiles. Adjustments to temperature and timing have led to a delightful spectrum of aromas, promising to elevate our confectionery creations to new heights.'),
(14, 'Intricate Snowflake Ornament Design', 'This design blueprint outlines the geometric intricacies of a multi-faceted snowflake ornament, emphasizing a balance between elegance and structural integrity. Each arm is meticulously patterned to reflect light, creating a shimmering effect that dances with the seasons, while ensuring optimal symmetry for enchanting visual appeal.'),
(15, 'Gift Box Assembly Prototype', 'This prototype outlines the intricate process of assembling the enchanted gift boxes designed to withstand the whims of time and space. Each step must be meticulously executed to ensure that every box not only sparkles with joy but also maintains its magical properties through every unwrapping.'),
(16, 'Wrap-It-Up: Innovative Designs', 'This experimental report explores various materials and techniques for creating enchanted wrapping paper that enhances the gift-giving experience. Initial findings suggest that incorporation of shimmering elven dust can amplify the aesthetic appeal while maintaining structural integrity during airborne delivery.'),
(17, 'Magical Confection Fusion Results', 'The experimental concoction blended sugar crystals with essence of starlight, resulting in a luminescent treat that sparkles enchantingly. However, a curious side effect was noted: excessive giggling among taste testers, raising questions about potential airborne laughter.'),
(18, 'Luminous Ornament Crafting Techniques', 'In our continuous pursuit of radiance, this document outlines innovative methods for creating ornaments that glow with enchantment. Engaging both traditional techniques and modern enchantments, each design is meant to instill joy and sparkle during the festive season.'),
(19, 'Magical Energy Conduction Analysis', 'Recent experiments have shown that the flow of magical energy through crystalline conduits behaves unpredictably under varying lunar phases. Further investigation into the correlation between ambient mana levels and energy stability is necessary to optimize enchantment potency.'),
(20, 'Elven Workshop Organization Protocols', 'The implementation of open shelving systems has significantly increased accessibility to essential materials, thus enhancing workflow efficiency. Furthermore, the organization of tools into color-coded bins ensures that each elf can swiftly locate their required implements without disrupting the harmony of the workshop.');
We have just one table and a couple of text like columns. That’s it, looks like a string searching problem.
It was winding down week, 2025, ending slowly, the biggest irony. The year was full of fast-paced, unprecedented models just dropping here and there. It was hard to keep up with the progress. It was getting overwhelming, no one is used to such a level of information. I was dreading with so much power in our hands. I couldn’t handle it and refrained it and thought it was better to focus on learning new things. I kept using AI tools at work, not by choice, but initially through force but then through necessity.
All right, this is day 11 from Advent of SQL.
Let’s pull in the data.
DROP TABLE IF EXISTS behavior_logs;
CREATE TABLE behavior_logs (
id INT PRIMARY KEY,
child_id INT,
child_name TEXT,
behavior_date DATE,
score INT
);
INSERT INTO behavior_logs (id, child_id, child_name, behavior_date, score) VALUES
(1, 1, 'Emma D.', '2025-12-01', 5),
(2, 1, 'Emma D.', '2025-12-02', 1),
(3, 1, 'Emma D.', '2025-12-03', 3),
(4, 1, 'Emma D.', '2025-12-04', 5),
(5, 1, 'Emma D.', '2025-12-05', 2),
(6, 1, 'Emma D.', '2025-12-06', 2),
(7, 1, 'Emma D.', '2025-12-07', 3),
(8, 1, 'Emma D.', '2025-12-08', 5),
(9, 1, 'Emma D.', '2025-12-09', 4),
(10, 1, 'Emma D.', '2025-12-10', 5),
(11, 1, 'Emma D.', '2025-12-11', 5),
(12, 1, 'Emma D.', '2025-12-12', -1),
(13, 1, 'Emma D.', '2025-12-13', 1),
(14, 1, 'Emma D.', '2025-12-14', 1),
(15, 1, 'Emma D.', '2025-12-15', -1),
(16, 1, 'Emma D.', '2025-12-16', 3),
(17, 1, 'Emma D.', '2025-12-17', -2),
(18, 1, 'Emma D.', '2025-12-18', 1),
(19, 1, 'Emma D.', '2025-12-19', 1),
(20, 1, 'Emma D.', '2025-12-20', -2),
(21, 2, 'Ava X.', '2025-12-01', 0),
(22, 2, 'Ava X.', '2025-12-02', -1),
(23, 2, 'Ava X.', '2025-12-03', 4),
(24, 2, 'Ava X.', '2025-12-04', 0),
(25, 2, 'Ava X.', '2025-12-05', 2),
(26, 2, 'Ava X.', '2025-12-06', 3),
(27, 2, 'Ava X.', '2025-12-07', 5),
(28, 2, 'Ava X.', '2025-12-08', 2),
(29, 2, 'Ava X.', '2025-12-09', 1),
(30, 2, 'Ava X.', '2025-12-10', 5),
(31, 2, 'Ava X.', '2025-12-11', 2),
(32, 2, 'Ava X.', '2025-12-12', 5),
(33, 2, 'Ava X.', '2025-12-13', 5),
(34, 2, 'Ava X.', '2025-12-14', 2),
(35, 2, 'Ava X.', '2025-12-15', 0),
(36, 2, 'Ava X.', '2025-12-16', 0),
(37, 2, 'Ava X.', '2025-12-17', 5),
(38, 2, 'Ava X.', '2025-12-18', 4),
(39, 2, 'Ava X.', '2025-12-19', 5),
(40, 2, 'Ava X.', '2025-12-20', 5),
(181, 10, 'Ava C.', '2025-12-01', 3),
(182, 10, 'Ava C.', '2025-12-02', 0),
(183, 10, 'Ava C.', '2025-12-03', 3),
(184, 10, 'Ava C.', '2025-12-04', 5),
(185, 10, 'Ava C.', '2025-12-05', 5),
(186, 10, 'Ava C.', '2025-12-06', 4),
(187, 10, 'Ava C.', '2025-12-07', 1),
(188, 10, 'Ava C.', '2025-12-08', 4),
(189, 10, 'Ava C.', '2025-12-09', 5),
(190, 10, 'Ava C.', '2025-12-10', 5),
(191, 10, 'Ava C.', '2025-12-11', 5),
(192, 10, 'Ava C.', '2025-12-12', 0),
(193, 10, 'Ava C.', '2025-12-13', 0),
(194, 10, 'Ava C.', '2025-12-14', 3),
(195, 10, 'Ava C.', '2025-12-15', 1),
(196, 10, 'Ava C.', '2025-12-16', 3),
(197, 10, 'Ava C.', '2025-12-17', -1),
(198, 10, 'Ava C.', '2025-12-18', 0),
(199, 10, 'Ava C.', '2025-12-19', 5),
(200, 10, 'Ava C.', '2025-12-20', 4),
(241, 13, 'Ava R.', '2025-12-01', 3),
(242, 13, 'Ava R.', '2025-12-02', 2),
(243, 13, 'Ava R.', '2025-12-03', 2),
(244, 13, 'Ava R.', '2025-12-04', 1),
(245, 13, 'Ava R.', '2025-12-05', -1),
(246, 13, 'Ava R.', '2025-12-06', -1),
(247, 13, 'Ava R.', '2025-12-07', 2),
(248, 13, 'Ava R.', '2025-12-08', 5),
(249, 13, 'Ava R.', '2025-12-09', 0),
(250, 13, 'Ava R.', '2025-12-10', 5),
(251, 13, 'Ava R.', '2025-12-11', 2),
(252, 13, 'Ava R.', '2025-12-12', -1),
(253, 13, 'Ava R.', '2025-12-13', 2),
(254, 13, 'Ava R.', '2025-12-14', 3),
(255, 13, 'Ava R.', '2025-12-15', 2),
(256, 13, 'Ava R.', '2025-12-16', -1),
(257, 13, 'Ava R.', '2025-12-17', -2),
(258, 13, 'Ava R.', '2025-12-18', -4),
(259, 13, 'Ava R.', '2025-12-19', -3),
(260, 13, 'Ava R.', '2025-12-20', 2),
(1961, 99, 'Ava X.', '2025-12-01', 2),
(1962, 99, 'Ava X.', '2025-12-02', -2),
(1963, 99, 'Ava X.', '2025-12-03', -1),
(1964, 99, 'Ava X.', '2025-12-04', -2),
(1965, 99, 'Ava X.', '2025-12-05', 3),
(1966, 99, 'Ava X.', '2025-12-06', -1),
(1967, 99, 'Ava X.', '2025-12-07', 0),
(1968, 99, 'Ava X.', '2025-12-08', 1),
(1969, 99, 'Ava X.', '2025-12-09', 0),
(1970, 99, 'Ava X.', '2025-12-10', 0),
(1971, 99, 'Ava X.', '2025-12-11', 3),
(1972, 99, 'Ava X.', '2025-12-12', 4),
(1973, 99, 'Ava X.', '2025-12-13', 4),
(1974, 99, 'Ava X.', '2025-12-14', 0),
(1975, 99, 'Ava X.', '2025-12-15', 3),
(1976, 99, 'Ava X.', '2025-12-16', -1),
(1977, 99, 'Ava X.', '2025-12-17', -1),
(1978, 99, 'Ava X.', '2025-12-18', 3),
(1979, 99, 'Ava X.', '2025-12-19', 3),
(1980, 99, 'Ava X.', '2025-12-20', -3);
No hiccups! Good to go.