# 一个剧集可能有多个广告,因此需要去重SELECT session_id
FROM Playback
WHERE session_id NOTIN(SELECTdistinct p.session_id
FROM Ads a
INNERJOIN Playback p
ON a.customer_id=p.customer_id AND a.timestampBETWEEN p.start_time AND p.end_time
)
1.3 运行截图
2 平均售价
2.1 题目内容
2.1.1 基本题目信息1
2.1.2 基本题目信息2
2.1.3 示例输入输出
a 示例输入
b 示例输出
2.2 示例sql语句
# Write your MySQL query statement belowSELECT p.product_id,ROUND(SUM(p.price*u.units)/SUM(u.units),2) average_price
FROM Prices p
INNERJOIN UnitsSold u
ON p.product_id=u.product_id AND u.purchase_date between p.start_date and p.end_date
GROUPBY p.product_id
2.3 运行截图
3 求团队人数
3.1 题目内容
3.1.1 基本题目信息
3.1.2 示例输入输出
3.2 示例sql语句
# Write your MySQL query statement belowSELECT e1.employee_id,e2.team_size
FROM Employee e1
INNERJOIN(SELECT team_id,count(employee_id) team_size
FROM Employee
GROUPBY team_id
)e2
ON e1.team_id=e2.team_id