Skip to content

Instantly share code, notes, and snippets.

View chrisdmell's full-sized avatar

Chris Aloysius Dmello chrisdmell

View GitHub Profile
@chrisdmell
chrisdmell / apriori.sql
Created May 24, 2022 07:15
Apriori Algorithm in SQL
with base as
(
SELECT *
FROM Product_Details_002
where Product_ID is not null
),
inner_joined_cte as
(
select a. Order_ID, a. Product_ID as puller_Art, b. Product_ID as pulled_art
from base as a