Calculating Average Cost Over Date Range with Latest Cost in Single SQL Query

Converting Timestamps in Microsoft Access: A Guide to Calculating Average Date/Time as a Decimal Number

Data Manipulation with R: A Guide to Concatenating and Averaging Values in a Data Frame