pta Mysql题目集 (81-100)

10-81 3-1-(c)查询在st1公司于2018年制作的电影中出演的影星

select distinct starName
from StarsIn,Movie
where StarsIn.movieTitle=Movie.title and StarsIn.movieYear=Movie.year and year=2018 and studioName='st1';

10-82 A1-2根据所在国家查找订单信息

select OrderID,CustomerID
from orders
-- where ShipCountry in ('Germany','Brazil','France');
where ShipCountry = 'Germany' or ShipCountry = 'Brazil' or ShipCountry = 'France';

10-83 A1-3查询顾客表中所有不重复的城市

select distinct City
from customers;

10-84 A1-4在产品表中找出库存数量大于50的产品的信息

select ProductID,ProductName
from products
where UnitsInStock>50

10-85 3-1-(d)查询比电影《M1》时间更长的电影

sel