help with a select statement

[Whitlock, Brett]

Has someone got a handy dandy select statement that will give me client
names and the number of backup and archive files by management class?
 
Thanks 
 
Brett