I have a question relating tables in MySQL. To understand this better I'd rather show you. I have the following table:

```
CREATE TABLE IF NOT EXISTS `tip_masina` (
  `id_tip` int(11) NOT NULL AUTO_INCREMENT,
  `marca` varchar(40) NOT NULL,
  `pret` int(11) NOT NULL,
  PRIMARY KEY (`id_tip`),
  UNIQUE KEY `marca` (`marca`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

INSERT INTO `tip_masina` (`id_tip`, `marca`, `pret`) VALUES
(1, 'Chevrolet Impala', 8000),
(2, 'Chevrolet Camaro', 10000),
(3, 'Chevrolet Tahoe', 13000),
(4, 'Chevrolet Suburban', 12500),
(5, 'Chevrolet Cobalt', 4000),
(6, 'Dodge Charger', 14000),
(7, 'Dodge Avenger', 9000),
(8, 'Dodge Challenger', 6500),
(9, 'Dodge Dart', 3500),
(10, 'Dodge Durango', 3000),
(11, 'Ford Mustang', 7500),
(12, 'Ford Crown Victoria', 5000),
(13, 'Ford Focus', 4300),
(14, 'Ford Fiesta', 3700),
(15, 'Ford Escort', 1000);

```

What I want out of this table is to display the vehicle type and the number of vehicles, like:

```
marca      |  no_of_vehicles
Chevrolet          5
Dodge              5
Ford               5

```

Is there any way to do this without splitting the column marca in two columns?