一个数据表express(No, SenderName, ReceiverName, SenderAddress, ReceiverAddress, Charge, Weight, Type),以下不能完成对应操作的sql语句是()?
查询所有重量在10kg以下的快递,并输出单号和收费<br>Select No, Charge From express Where Weight < 10
查询所有寄件人第一个字为“李”的快递单<br>Select * From express Where name like “李%”
统计表中快递单共有多少种类型<br>Select count(*) From (Select Type From express)
统计表中不同类型的快递单的平均重量,并按从大到小排列<br>Select Type, avg(Weight) From express Group by Type Order by avg(Weight)