Help With Query

Question

I need some help building a query. I have an issue table that, among other things, stores a PriorityLevelId. I have a Priority Table that just has 2 columns, Id and Level. PriorityLevelId is a foreign key to the Id column in the Priority Table. There are only 3 types of priorites. Minor, Hendering, and Halting. What I need is a query that will get a total of each priority type for a given day (say today) and return those to me with the corosponding type. So something like Minor 21 Hendering 32 Halting 15 I am using MS SQL Server 2000. Can someone give me a hand with this? Thanks.