Company: Electronic arts _30oct
Difficulty: medium
Problem Description To forecast vehicle part purchases, you need an overview of the most common vehicle makes among your customers. Write a SQL query to calculate the total number of vehicles per vehicle make. The result should only include vehicle makes that have two or more vehicles. Schema The query will be executed against a database containing a vehicles table with the following structure: id (INT): A unique identifier for the vehicle. make (VARCHAR): The make or brand of the vehicle. Required Output Your query should return a result set with the following columns in exact order: make : The make of the vehicle. vehicle_make_count : The total number of vehicles belonging to this make. Constraints or Notes Only include vehicle makes with a vehicle_make_count >= 2. The final result must be ordered alphabetically by make in ascending order. Assume standard SQL syntax. Examples Example 1: Input: vehicles table | id | make | |----|--------| | 1 | Ford | | 2 | Toyota | | 3 | Ford | |