SUM of multiple rows based on ranking
I have a db like so with thousands of job numbers and the workers on each job:
how to select 3 max dates with on multiple IDs
If i have a table with multiple customer IDs, and each customer has orders on different dates, I need to select each customer and their last 3 orders with their dates.