This solution to last week's challenge can be found HERE.
A website log tracks every click visitors are making on a particular link on the site in order to measure interest in the link.
However, web consumers are impatient and may click a link multiple times in short succession.
The goal of this exercise is to flag "duplicate clicks" that is defined as the event fire date happening within 30 seconds of the previous event fire date for the same user (IDFA) and device (DeviceID)
I included a sort (to make sure that data is in time order). Your challenges almost make Monday's something to look forward to..