I have table named `vehicledata` which consists 3 columns: `id`, `Veh No`, and `Veh Mode`.

My data looks like this:

```
id  Veh No  Veh Mode
1   KA03-003    IDLE
2   KA03-003    IDLE
3   KA03-003    IDLE
4   KA03-003    DRIVE
5   KA03-003    DRIVE
6   KA03-003    DRIVE
7   KA03-003    DRIVE
8   KA03-003    DRIVE
9   KA03-003    IDLE
10  KA03-003    IDLE
11  KA03-003    IDLE
12  KA03-003    DRIVE
13  KA03-003    DRIVE
14  KA03-003    DRIVE
15  KA03-003    DRIVE
16  KA05-005    IDLE
17  KA05-005    IDLE
18  KA05-005    IDLE
19  KA05-005    DRIVE
20  KA05-005    DRIVE
21  KA05-005    DRIVE
22  KA05-005    DRIVE
23  KA05-005    DRIVE
24  KA05-005    IDLE
25  KA05-005    IDLE
26  KA05-005    IDLE
27  KA05-005    DRIVE
28  KA05-005    DRIVE
29  KA05-005    DRIVE
30  KA05-005    DRIVE

```

In the above table there are 2 Veh No i.e KA03-003 & KA05-005.
From id 4 to 8 & 12 to 15 there are two DRIVE cycles for KAO3-003 and From id 19 to 23 & 27 to 30 there are two DRIVE cycles for KAO5-005
For these Vehicles i need to get count of 'DRIVE' cycles occured in a table & result should look as below:

```
Veh No    No.of.Drive Cycles
KA03-003       2 
KA05-005       2

```

I am not able to write query.Kindly help me in solving this. Thanks in advance.