# SQL view for last sale by customer and item | Victoria Yudin

- URL: https://dynamicaccounting.net/sql-view-for-last-sale-by-customer-and-item-victoria-yudin/
- Date: 2011-03-30
- Topics: SQL & Data, Payables & Receivables, Sales, Purchasing & Inventory
- Type: link to an external article
- Source: https://victoriayudin.com/2011/03/29/sql-view-for-last-sale-by-customer-and-item/

Victoria Yudin delivers a new [SQL view for last sale by customer and item.](https://victoriayudin.com/2011/03/29/sql-view-for-last-sale-by-customer-and-item/) This got me thinking. With this as a base, I could figure out an average time between orders and then flag customers for followup if they haven’t ordered recently. hmmm…

![](/img/blogger/a07823fab4ec6a10.jpg)