Question

*SI schema contains customers that have bought one or more vehicles.
They can be classified using the following criteria:
Customers that have bought only one car (one-time buyer)
Customer that have bought two cars (two-time buyer)
Customers that have bought more than two cars (frequent buyer)
Using a SINGLE SELECT statement, display a list of customers with
their names and what type of buyer they are for all those customers
that have bought Mercedes car makes.

Answer 1

Answer:

SELECT name, type_of_buyer

FROM SI

WHERE car_make = 'Mercedes';

Here, name represents the name of customer column in table.

type_of_buyer represents the criteria of classification in table.

SI is the table name

car_make is column which represent car makes.