Skip to content

Instantly share code, notes, and snippets.

@konstantint

konstantint/dsw-2.sql

Created December 2, 2018 02:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save konstantint/b0e7d3af4943d8b472b70f18e77de97c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save konstantint/b0e7d3af4943d8b472b70f18e77de97c to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. konstantint created this gist Dec 2, 2018.
    10 changes: 10 additions & 0 deletions dsw-2.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,10 @@
    select
    s.Key
    v1.AverageTimeSpent,
    v1.NumberOfClicks,
    v2.Country
    v3.Purchase as Target
    from vw_TrainSample s
    left join vw_BehaviourFeatures v1 on v1.Key = s.Key
    left join vw_ProfileFeatures v2 on v2.Key = s.Key
    left join vw_TargetFeatures v3 on v3.Key = s.Key