Thanks Jeff for your response.

For the inputs that you have given, my expected output would be as follow:

Op imei_count

-- -----------

aa 4

Thanks and regards,

Mehfuz

Op is also char. Sorry about that.

I forgot to mention that it has a composite primary key as follows:

(msisdn, imei)