Create a report to display the combined customer name and total amount spent by each customer on the purchases. In your solution determine the customer rating as follows: If the total spent amount is greater than or equal to R 1 500 the customer receives a star rating, otherwise no star rating applies.
Sample Output:
FIRST NAME: Jack
SURNAME: Smith
AMOUNT: R 1798 (*)

FIRST NAME: Pat
SURNAME: Hendricks
AMOUNT: R 1299

FIRST NAME: Lucy
SURNAME: Williams
AMOUNT: R 1778 (*)

FIRST NAME: Andre
SURNAME: Clark
AMOUNT: R 799