Jun 13, 2018 10:17 PM|OfficerShark|LINK
Hey, I am looking for help, I am trying to work out this question below, but I am struggling to do it without repeating the data shown. If anyone can help that would be very appreciated!
QUESTION: Display a list of all sales, by customer, showing the customer ID, the customer’s name, the name of the product bought by the customer and the date of sale.
The list should be sorted by Customer ID, then by date of sale with the most recent date first.
The customer’s forename and surname should be merged to form one column in the display.
Display all data with suitable column headings.