SQL语句中的子查询应用

某公司的面试考核题：

销售信息表 tbSaleInfo

   DeviceNo        设备编号
   GoodNo          货道编号(1-24)
   CardNo          卡号
   Money           消费金额
   Balance         卡片余额   
   SaleFlowNo      售卖流水号
   SaleTime        售卖时间
   CollectionTime  采集时间
   Mode        销售类型
               Mode = 0  表示现金消费，此时卡号=0，卡片余额=0
               Mode = 4  表示持卡消费，此时卡号有效，卡片余额有效

要求：

按设备编号查询：设备编号、开始日期 - 截止日期
输出信息字段：设备编号、销售日期、现金销售数量、现金销售金额、IC卡销售数量、IC卡销售金额、总销售数量、总销售金额
现金：销售日志 Mode = 0
IC卡：销售日志 Mode = 4
指定日期范围内每天一条销售信息，按照日期排序

我的方法：

@DeviceNo ，@SaleTime 和 @SaleTime2  本别对应三个参数：设备编号、开始日期 - 截止日期。

SELECT 
    @DeviceNo AS 设备编号, 
    CONVERT(varchar(10), SaleTime, 120) AS 销售日期,
    
    (SELECT COUNT(Id) AS Expr1 
    FROM tbSaleInfo AS tbSaleInfo_1 
    WHERE (DeviceNo = @DeviceNo) AND (Mode = 0) AND (CONVERT(varchar(10), SaleTime, 120) = CONVERT(varchar(10), tbSaleInfo.SaleTime, 120)) 
    GROUP BY CONVERT(varchar(10), SaleTime, 120)) 
    AS 现金销售数量, 
    
    (SELECT SUM([Money]) AS Expr1 
    FROM tbSaleInfo AS tbSaleInfo_1 
    WHERE (DeviceNo = @DeviceNo) AND (Mode = 0) AND (CONVERT(varchar(10), SaleTime, 120) = CONVERT(varchar(10), tbSaleInfo.SaleTime, 120)) 
    GROUP BY CONVERT(varchar(10), SaleTime, 120)) 
    AS 现金销售金额, 
    
    (SELECT COUNT(Id) AS Expr1 
    FROM tbSaleInfo AS tbSaleInfo_1 
    WHERE (DeviceNo = @DeviceNo) AND (Mode = 4) AND (CONVERT(varchar(10), SaleTime, 120) = CONVERT(varchar(10), tbSaleInfo.SaleTime, 120)) 
    GROUP BY CONVERT(varchar(10), SaleTime, 120)) 
    AS IC卡销售数量, 
    
    (SELECT SUM([Money]) AS Expr1 
    FROM tbSaleInfo AS tbSaleInfo_1 
    WHERE (DeviceNo = @DeviceNo) AND (Mode = 4) AND (CONVERT(varchar(10), SaleTime, 120) = CONVERT(varchar(10), tbSaleInfo.SaleTime, 120)) 
    GROUP BY CONVERT(varchar(10), SaleTime, 120)) 
    AS IC卡销售金额, 
    
    COUNT(Id) AS 总销售数量, 
    
    SUM([Money]) AS 总销售金额 
FROM tbSaleInfo 
WHERE (DeviceNo = @DeviceNo) AND (SaleTime BETWEEN @SaleTime AND @SaleTime2) 
GROUP BY CONVERT(varchar(10), SaleTime, 120) 
ORDER BY 销售日期

我想到的貌似只有子查询了，前辈们多多指教！