Database: vehicle_rent
Question: Show all types of powertrain and the number of vehicles in each type.
SQL:
SELECT type_of_powertrain ,  count(*) FROM vehicles GROUP BY type_of_powertrain