题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
SELECT session_id FROM Playback p LEFT JOIN Ads a ON timestamp BETWEEN start_time AND end_time AND p.customer_id = a.customer_id WHERE ad_id IS NULL
题目链接:点击打开链接
题目大意:略。
解题思路:略。
AC 代码
SELECT session_id FROM Playback p LEFT JOIN Ads a ON timestamp BETWEEN start_time AND end_time AND p.customer_id = a.customer_id WHERE ad_id IS NULL