Cacher is the code snippet organizer for pro developers

Select DISTINCT r.timestamp AS timestamp_UTC, DATEADD(hour,-5,r.timestamp) AS timestamp_EST, p.unique_name AS username, u.name ,
r.remote_ip as IP, r.user_agent, r.URL
From requests r
LEFT JOIN pseudonym_dim p ON r.user_id = p.user_id
LEFT JOIN user_dim u ON r.user_id = u.id
Where url like '%courses/52212/quizzes/255725/edit%';