Skip to content

Instantly share code, notes, and snippets.

@montanalow

montanalow/buy_it_again_nested.sql

Created February 6, 2021 00:43
Show Gist options
  • Save montanalow/0b031310f4afdbbaaf82598a3cc5ed8c to your computer and use it in GitHub Desktop.
Save montanalow/0b031310f4afdbbaaf82598a3cc5ed8c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
buy_it_again_nested.sql
CREATE TABLE buy_it_again (
customer_id INTEGER NOT NULL,
product_ids INTEGER[] NOT NULL,
purchase_counts INTEGER[] NOT NULL
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment