Skip to content

1809. Ad-Free Sessions

1
2
3
4
5
6
7
SELECT Playback.session_id
FROM Playback
LEFT JOIN Ads
  ON (
    Playback.customer_id = Ads.customer_id
    AND Ads.timestamp BETWEEN Playback.start_time AND Playback.end_time)
WHERE Ads.ad_id IS NULL;