Database: vehicle_rent
Question: How many vehicles have each type of powertrain?
SQL:
SELECT type_of_powertrain ,  count(*) FROM vehicles GROUP BY type_of_powertrain