Each vehicle id and its type report

Vehicle Id: vehicle 1  Vehicle Type: Big Wheel
Vehicle Id: vehicle 2  Vehicle Type: Bicycle
Vehicle Id: vehicle 3  Vehicle Type: Motorcycle
Vehicle Id: vehicle 4  Vehicle Type: Hang Glider
Vehicle Id: vehicle 5  Vehicle Type: Car
Vehicle Id: vehicle 5  Vehicle Type: Car

Type of vehicle summary

Total no of vehicle: 6

Big Wheel: 1
Bicycle: 1
Motorcycle: 1
Hang Glider: 1
Car: 2
