pta mysql训练题集 (101-120)

10-101 spj-查询比p6零件供应数量都高的零件

select distinct pno
from spj
where pno not in 
(
    select pno from spj where qty<=(select max(qty) from spj where pno='p6')
);

10-102 A3-1查询订单表中的平均运费

select avg(Freight) as avgFreight
from orders;

10-103 A3-2查询国家为Mexico、Germany的客户数量

select count(*) as custCount
from customers
where Country in ('Mexico','Germany');

10-104 A3-3查找产品表中最低的单价

select min(UnitPrice) as minUnitPrice
from products;

10-105 A3-4查询产品表中最大库存量

select max(UnitsInStock) as maxUnitsInStock
from products;