By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) Jul 25 2020 11:26:55 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
7 rows affected
3 rows affected
Event_Day | Member_ID | CV1 | CV2 | CV3 | CV4 |
---|---|---|---|---|---|
2021-11-05 | 183300 | APP | camp1 | Trigger | APP-camp1-Trigger |
2021-11-14 | 183300 | SEARCH | camp4 | Search | SEARCH-camp4-Search |
2021-11-04 | 193320 | SEARCH | camp5 | Search | SEARCH-camp5-Search |
2021-11-08 | 193320 | SEARCH9 | camp5 | Search | SEARCH-camp5-Search |
2021-11-06 | 193320 | SEARCH2 | camp6 | Search | SEARCH-camp6-Search |
2021-11-07 | 193320 | SEARCH1 | camp7 | Search | SEARCH-camp7-Search |
2021-11-10 | 141542 | SEARCH1 | camp7 | Search | SEARCH-camp7-Search |
Date | Purchase_Order_ID | Membership_Number | Order_Value |
---|---|---|---|
2021-12-07 | 0088 | 183300 | 29.34 |
2021-12-18 | 0180 | 193320 | 132.51 |
2021-12-04 | 0050 | 141542 | 24.35 |
Event_Day | Member_ID | CV1 | CV2 | CV3 | CV4 | Date | Purchase_Order_ID | Membership_Number | Order_Value | rnk |
---|---|---|---|---|---|---|---|---|---|---|
2021-11-10 | 141542 | SEARCH1 | camp7 | Search | SEARCH-camp7-Search | 2021-12-04 | 0050 | 141542 | 24.35 | 1 |
2021-11-05 | 183300 | APP | camp1 | Trigger | APP-camp1-Trigger | 2021-12-07 | 0088 | 183300 | 29.34 | 1 |
2021-11-04 | 193320 | SEARCH | camp5 | Search | SEARCH-camp5-Search | 2021-12-18 | 0180 | 193320 | 132.51 | 1 |
Event_Day | Member_ID | CV1 | CV2 | CV3 | CV4 | Date | Purchase_Order_ID | Membership_Number | Order_Value |
---|---|---|---|---|---|---|---|---|---|
2021-11-10 | 141542 | SEARCH1 | camp7 | Search | SEARCH-camp7-Search | 2021-12-04 | 0050 | 141542 | 24.35 |
2021-11-05 | 183300 | APP | camp1 | Trigger | APP-camp1-Trigger | 2021-12-07 | 0088 | 183300 | 29.34 |
2021-11-04 | 193320 | SEARCH | camp5 | Search | SEARCH-camp5-Search | 2021-12-18 | 0180 | 193320 | 132.51 |