hard.sql

hard.sql

-- SQL query you end up writing
WITH table1 AS (
     SELECT ...
     FROM ...
     GROUP BY ...
)
,table2 AS (
     SELECT ...
     FROM ...
     GROUP BY ...
)
,table3 AS (
     SELECT ...
     FROM ...
)
SELECT
     feature1,
     feature2,
     ... 
     featureN,
     target
FROM
    table1 
    INNER JOIN table2
    LEFT JOIN table3