Hi,
So i need to bring back the results to show the oldest order and the newest order date with a count on total orders for a customer fields i wish to include are:
Customer_ID
Order Date
Need to show:
Customer_ID ¦ Count Of Orders ¦ First Order Date ¦ Last Order Date
123 ¦ 4 ¦ 01/04/2022 ¦ 01/01/2023
would love some help
So i need to bring back the results to show the oldest order and the newest order date with a count on total orders for a customer fields i wish to include are:
Customer_ID
Order Date
Need to show:
Customer_ID ¦ Count Of Orders ¦ First Order Date ¦ Last Order Date
123 ¦ 4 ¦ 01/04/2022 ¦ 01/01/2023
would love some help