'group By' And 'substrings' Query Help

i have a table like this:


Code:

Product
id - varchar(10)
description - text



the ids are something like this
mod01-01
mod02-01
mod03-01
mod01-02
mod02-02
mod03-02
mod03-03
mod03-04
mod04-01
....

now, i am trying to group by and count all of the ids that end with '01',

i was thinking of something like
select count(id)
group by id
where id= ???

and the second query i need to make is one that counts not one but all the ids that end with the same last 2 digits but in one single query, how can i do that? as a possible hint, is that the only thing i KNOW that the last 2 digits can only be 01,02,03,04 and 05 but still im a bit stuck in here the result should look something like this

id total
01 4
02 3
03 1
04 1

or what suggestions can you give me for this query? even if you just help me with the first query, that would be great, thanks!!
thanks!!!