SELECT p.product_name,o.unit
FROM(SELECT product_id,sum(unit) unit
FROM Orders
WHERE date_format(order_date,"%Y-%m")='2020-02'GROUPBY product_id
HAVINGsum(unit)>=100) o
INNERJOIN Products p
ON o.product_id=p.product_id
2.3 运行截图
3 院系无效的学生
3.1 题目内容
3.1.1 基本题目信息
3.1.2 示例输入输出
a 示例输入
b 示例输出
3.2 示例sql语句
SELECT id,name
FROM Students
WHERE department_id NOTIN(SELECT id
FROM Departments
)