I just finished the CoolTShirt project here [https://gist.github.com/04b80a8f44d1615b45384e9a395c5b89] But my final query wasnt running and i couldnt figure out the reason why
I am a newbie, but on a quick look, I see as follows… I do not thing you can include the WHERE clause before ON… I do think that ON should immediately follow JOIN:
FROM page_visits pv
JOIN last_touch lt
ON pv.user_id = lt.user_id
AND pv.timestamp = lt.last_touch_at
WHERE page_name = '4 - purchase'