Skip to content

Instantly share code, notes, and snippets.

@nfarah86

nfarah86/get_customer_last_purchase.sql

Last active September 15, 2022 06:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nfarah86/fefab18bd376ac25fd13cc80c7184b4e to your computer and use it in GitHub Desktop.
Save nfarah86/fefab18bd376ac25fd13cc80c7184b4e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
get_customer_last_purchase.sql
SELECT
u.user_id,
_event_time,
u.purchased
FROM
kafkaWorkshop.CustomerPurchaseActivities u
WHERE
u.user_id = :userid
ORDER BY
_event_time desc
LIMIT
1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment