Chapter 12: SQL pagination of invoices is non-deterministic and doesn't show all invoices

When creating new invoices, we truncate the Date to remove the timestamp resulting in all new invoices to have an identical value in our SQL database

When the invoices are then fetched, ordered, and limited to be displayed in a table, SQL does not have enough data to guarantee a unique ordering