Simple MYSQL Query

[Duka]

Hello everyone, I have two tables: customer table and purchase table. In the purchase section, each customer can make multiple purchases. Now, how can we generate a page showing the customer's name, surname, and the total number of vehicles they have purchased by counting the number of vehicles each customer has bought? Thank you.