SQL Server2012关于表内事项出现次数降序排列（存储过程）

USE [growup]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE  [dbo].[S_GetRankingList]
@timestart datetime,
@timeend datetime
AS
BEGIN

    SET NOCOUNT ON;

    select *
    from(
    SELECT
     count(1) as t,
     S_BigClass as bc,
     S_SmallClass as sc,
     S_MatterName as mn from S_Matter
     where 
     @timestart<=S_PlanStart
     and @timeend>=S_PlanStart
     group by S_BigClass,S_SmallClass,S_MatterName
     )as c
     order by t desc
END