Debug: a duplicate scan is not another delivery

Return day and delivered_packages (packages with a delivered scan that day) for March 2025. The query counts scans. Fix it.

what to return

Columns: daydelivered_packages in this order
Rows: 30 rows · any order
Skill: Repair the query’s logic and confirm the fix on changed data. Refresher: Deduplicate event retries →

expected result

Your query should return exactly these columns and values. Run it and compare.

expected result30 rows · any order

day	delivered_packages
2025-03-01	5
2025-03-02	1
2025-03-03	250

first 3 of 30 rows

data you can query

Logistics dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.

tracking_events9 columns · 100,515 rows

event_idnumber · unique id	package_idnumber · links to packages	event_typetext	event_atdate & time	recorded_atdate & time	warehouse_idnumber · links to warehouses	event_sourcetext	exception_codetext	driver_idnumber
1	6359	created	2025-01-01 00:03:46	2025-01-01 00:04:36	NULL	manual	NULL	NULL
2	10950	created	2025-01-01 00:33:12	2025-01-01 00:35:16	NULL	manual	NULL	NULL
3	2045	created	2025-01-01 00:35:00	2025-01-01 00:37:08	NULL	manual	NULL	NULL
4	5977	created	2025-01-01 00:47:34	2025-01-01 00:48:13	NULL	manual	NULL	NULL
5	4930	created	2025-01-01 00:55:09	2025-01-01 00:57:10	NULL	manual	NULL	NULL
6	6331	created	2025-01-01 01:34:23	2025-01-01 01:35:30	NULL	manual	NULL	NULL

event_idnumber · unique id: 1
package_idnumber · links to packages: 6359
event_typetext: created
event_atdate & time: 2025-01-01 00:03:46
recorded_atdate & time: 2025-01-01 00:04:36
warehouse_idnumber · links to warehouses: NULL
event_sourcetext: manual
exception_codetext: NULL
driver_idnumber: NULL

event_idnumber · unique id: 2
package_idnumber · links to packages: 10950
event_typetext: created
event_atdate & time: 2025-01-01 00:33:12
recorded_atdate & time: 2025-01-01 00:35:16
warehouse_idnumber · links to warehouses: NULL
event_sourcetext: manual
exception_codetext: NULL
driver_idnumber: NULL

event_idnumber · unique id: 3
package_idnumber · links to packages: 2045
event_typetext: created
event_atdate & time: 2025-01-01 00:35:00
recorded_atdate & time: 2025-01-01 00:37:08
warehouse_idnumber · links to warehouses: NULL
event_sourcetext: manual
exception_codetext: NULL
driver_idnumber: NULL

event_idnumber · unique id: 4
package_idnumber · links to packages: 5977
event_typetext: created
event_atdate & time: 2025-01-01 00:47:34
recorded_atdate & time: 2025-01-01 00:48:13
warehouse_idnumber · links to warehouses: NULL
event_sourcetext: manual
exception_codetext: NULL
driver_idnumber: NULL

event_idnumber · unique id: 5
package_idnumber · links to packages: 4930
event_typetext: created
event_atdate & time: 2025-01-01 00:55:09
recorded_atdate & time: 2025-01-01 00:57:10
warehouse_idnumber · links to warehouses: NULL
event_sourcetext: manual
exception_codetext: NULL
driver_idnumber: NULL

event_idnumber · unique id: 6
package_idnumber · links to packages: 6331
event_typetext: created
event_atdate & time: 2025-01-01 01:34:23
recorded_atdate & time: 2025-01-01 01:35:30
warehouse_idnumber · links to warehouses: NULL
event_sourcetext: manual
exception_codetext: NULL
driver_idnumber: NULL

first 6 of 100,515 rows · your queries use all of them

solution.sql

Hints and the answer are always available. Using them counts the question as solved with help.