I agree with OriginalGriff, try looking at this query and see if you can adapt it to your needs though:
DECLARE @TRN_Queue TABLE
(
QueueNo NVARCHAR(5),
[Date] DATETIME2
);
INSERT INTO @TRN_Queue VALUES('3B001', '5-10-2014')
INSERT INTO @TRN_Queue VALUES('3B002', '5-09-2014')
INSERT INTO @TRN_Queue VALUES('3B003', '5-09-2014')
INSERT INTO @TRN_Queue VALUES('3G004', '5-11-2014')
INSERT INTO @TRN_Queue VALUES('3G005', '5-11-2014')
INSERT INTO @TRN_Queue VALUES('2P001', '5-11-2014')
INSERT INTO @TRN_Queue VALUES('2G002', '5-11-2014')
INSERT INTO @TRN_Queue VALUES('2P003', '5-08-2014')
INSERT INTO @TRN_Queue VALUES('1P001', '5-11-2014')
SELECT SUBSTRING(QueueNo, 1, 1), COUNT(SUBSTRING(QueueNo, 1, 1)), COUNT(SUBSTRING(QueueNo, 1, 1)) OVER() FROM @TRN_Queue
GROUP BY SUBSTRING(QueueNo, 1, 1)
Hope it helps...