题库 产品/项目/运营 题目列表 一个数据表express(No, SenderName, ReceiverName, Se...
单选题

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

A.

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

B.

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

C.

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

D.

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

题目信息
校招真题
-
正确率
0
评论
7
点击