Question $6$

$($Marks: $20)$

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 $R1500$ the customer receives a star rating, otherwise no star rating applies.

Sample Output: