Jun 14, 2018 02:16 PM|limno|LINK
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.
If these data are in different tables, you need to join these tables with the common key in a SELECT statement.(I assume you have relevant tables in your database).
The list should be sorted by Customer ID, then by date of sale with the most recent date first.
This is to use ORDER BY for your SELECT statement at the end.
Order by CustomerID, saleDate DESC
The customer’s forename and surname should be merged to form one column in the display.
You concat two columns together. You may use the new function concat(forename ,' ',surname) as fullname
Display all data with suitable column headings.
Use column alias for each column to show the heading you need. If you have space inside the heading, you need to use  to wrap them.
For example, you have Customer ID column, you can use an alias like this in the final SELECT statement:
SELECT Customer ID as [Customer ID],concat(forename ,' ',surname) as fullname, salesDate as [Sale Date]
from Customer Join Sale on Customer.CustomerID=Sale.CustomerID
You can get start with this tutorial: