A customer has a Sales data table and needs a chart to display sales figures by date, including dates without sales.
The Sales table is sorted by the primary key which is generated based on the type of order and the SalesPersonID who generated it.
Which technique should a developer use to achieve this requirement?