单选题

一个数据表express(No, SenderName, Receiver...

Question

一个数据表express(No, SenderName, ReceiverName, SenderAddress, ReceiverAddress, Charge, Weight, Type)，以下不能完成对应操作的sql语句是（）？

A. 查询所有重量在10kg以下的快递，并输出单号和收费<br>Select No, Charge From express Where Weight &lt 10

B. 查询所有寄件人第一个字为&ldquo李&rdquo的快递单<br>Select * From express Where name like &ldquo李%&rdquo

C. 统计表中快递单共有多少种类型<br>Select count（*） From (Select Type From express)

D. 统计表中不同类型的快递单的平均重量，并按从大到小排列<br>Select Type, avg(Weight) From express Group by Type Order by avg(Weight)