求一条sql语句

Question

现有2张表
-PCHOME_GOODS_INFO 商品信息表
--PCHOME_GOODS_INFO.ID                        IS '系统ID字段（商品ID）'     ;
--PCHOME_GOODS_INFO.GOODS_ID                  IS 'Pchome定义的商品ID'       ;                                                           
--PCHOME_GOODS_INFO.GOODS_NAME                IS '商品名称'                 ;                                                          
--PCHOME_GOODS_INFO.GOODS_PRICE               IS '商品价格（2499）'         ;
--PCHOME_GOODS_INFO.GOODS_SUBCATE             IS '商品自类别'               ;
    -- 手机：236,数码相机：103,平板电脑： 635,液晶电视：170,笔记本电脑：60
--PCHOME_GOODS_INFO.GOODS_NO                  IS '所属编号'                 ;
--PCHOME_GOODS_INFO.GOODS_TYPE_NAME           IS '商品自类别名称'           ;
--PCHOME_GOODS_INFO.GOODS_FORMAT_PRICE        IS '有币种符号的商品价格'     ;
--PCHOME_GOODS_INFO.GOODS_REG_DATE            IS '添加时间（接口提供）'     ;
--PCHOME_GOODS_INFO.GOODS_BRIEF               IS '简评'                   ;                                                           
--PCHOME_GOODS_INFO.GOODS_BIG_PIC             IS '大图片'                   ;                                                          
--PCHOME_GOODS_INFO.GOODS_MID_PIC             IS '中图片'                   ;
--PCHOME_GOODS_INFO.GOODS_SMALL_PIC           IS '小图片'                   ;
--PCHOME_GOODS_INFO.GOODS_SMALL_TITTLE_PIC    IS '小标题图片'               ;
--PCHOME_GOODS_INFO.GOODS_SD_SMALL_TITTLE_PIC IS '标清小标题图片'           ;
--PCHOME_GOODS_INFO.GOODS_TITTLE_PIC          IS '高清标题图片'             ;
--PCHOME_GOODS_INFO.GOODS_SD_TITTLE_PIC       IS '标清标题图片'             ;
--PCHOME_GOODS_INFO.GOODS_UPDATE_TIME         IS '更新时间'                 ;                                                           
--PCHOME_GOODS_INFO.GOODS_TYPE                IS '排行信息(0：新品 1：热门)';  
--PCHOME_GOODS_INFO.GOODS_ORDERBY             IS '商品排序'                 ; 
--PCHOME_GOODS_INFO.GOODS_CHECKED             IS '商品是否审核(1：未审核 2：已审核)'                 ; =================================================================================
--PCHOME_PICTURE 样张图评数据表
  --PCHOME_PICTURE.ID                          '系统ID字段'                                  
  --PCHOME_PICTURE.PCHOME_GOODS_INFO_ID        '商品信息表中的商品ID'                                                                                    
  --PCHOME_PICTURE.PCHOME_EVALUATION_ID        '商品图评表中的图评ID，样张数据此字段为空'                                                              
  --PCHOME_PICTURE.PIC_PATH                    '图片路径（只存储一张图片）'                   
  --PCHOME_PICTURE.SDPIC_PATH                  '标清图片路径（只存储一张图片  400 * 300）'               
  --PCHOME_PICTURE.THUMBNAIL_PIC               '缩略图地址（只存储一张图片 280 * 210）图评数据此字段为空'
  --PCHOME_PICTURE.PIC_TYPE                    '图片类型（1：图评图片 2：样张图片）'           
  --PCHOME_PICTURE.CHECK_FLAG                  '审核标志（0：未审核 1审核通过 2审核不通过）' =========================================================================
要求取出PCHOME_GOODS_INFO表数码相机数据记录，按照（PCHOME_PICTURE的PCHOME_GOODS_INFO_ID字段分组之后）统计的结果降序排序。最好带分页（int start,int end)。
PCHOME_GOODS_INFO.ID 对应PCHOME_PICTURE.PCHOME_GOODS_INFO_ID。目的是为了，将样张数量为0的商品排在后面。

Answer 1

SELECT T1.ID, COUNT(1)
  FROM PCHOME_GOODS_INFO T1
 INNER JOIN PCHOME_PICTURE T2 ON T1.ID = T2.PCHOME_GOODS_INFO_ID
 WHERE T1.GOODS_SUBCATE = '103'
 GROUP BY T2.PCHOME_GOODS_INFO_ID
 ORDER BY COUNT(1) DESC