I'm sorry, but I'm not entirely sure what this PR is intended to address. Since it's labeled as a fix, I would expect the PR description to include a related issue or an explanation of what the problem is and what the expected behavior should be.

@BrunoQuaresma fair point! This addresses the TODO comment here:
https://github.com/coder/coder/pull/16134/files#diff-1844f895bb005f036da11d800fe2a76b54bfddd481c5d8cb15f210c64679caa5R47

The backend now backfills dates with no changes. A previous PR also added sorting as mentioned in the same TODO.

Thanks @BrunoQuaresma.
All of the tests in coderd/database/querier_test.go TestGetUserStatusCounts test backfilling by asserting this:

for i, row := range userStatusChanges {
	require.True(
		t,
		row.Date.In(location).Equal(dbtime.StartOfDay(createdAt).AddDate(0, 0, i/2)),
		"expected date %s, but got %s for row %n",
		dbtime.StartOfDay(createdAt).AddDate(0, 0, i/2),
		row.Date.In(location).String(),
		i,
	)

We assert that we have an entry for every single date in the requested range.