# 多种条件可以考虑使用union 进行拼接(要去重)SELECT employee_id,department_id
FROM Employee
GROUPBY employee_id
HAVINGcount(department_id)=1UNIONSELECT employee_id,department_id
FROM Employee
WHERE primary_flag='Y'GROUPBY employee_id
HAVINGcount(department_id)>=1
2.3 运行截图
3 没有广告的剧集
3.1 题目内容
3.1.1 基本题目信息1
3.1.2 基本题目信息2
3.1.3 示例输入输出
3.2 示例sql语句
# Write your MySQL query statement belowSELECT p.session_id
FROM Playback p
LEFTJOIN Ads a
ON p.customer_id=a.customer_id AND a.timestampbetween start_time AND end_time
WHERE a.timestampisnull