Premium vs Freemium

StrataScratch

Find the total number of downloads for paying and non-paying users by date. Include only records where non-paying customers have more downloads than paying customers. The output should be sorted by earliest date first and contain 3 columns date, non-paying downloads, paying downloads.

table:ms_user_dimension


table:ms_acc_dimension


table:ms_download_facts


Solution Explanation:

  • We are going to apply inner join to combine all these 3 tables. table ms_user_dimension with table ms_acc_dimension with the common column account_id (acc_id ). Then table ms_download_facts with table ms_user_dimension with common table user_id.
  • Group by date to get sum of downloads of paying and non-paying users date wise.
  • Use case expression as below
  • Apply condition where non_paying downloads are more than paying downlods.
sum(case when a.paying_customer='yes' then f.downloads else 0 end) as  paying_cust_don,
sum(case when a.paying_customer='no' then f.downloads else 0 end) as  nonpaying_cust_don

Solution:

with cte as
(select f.date, 
sum(case when a.paying_customer='yes' then f.downloads else 0 end) as  paying_cust_don,
sum(case when a.paying_customer='no' then f.downloads else 0 end) as  nonpaying_cust_don
from ms_user_dimension as m
join ms_acc_dimension as a
on m.acc_id= a.acc_id
join ms_download_facts as f
on m.user_id = f.user_id
group by f.date)
select * from cte where paying_cust_don<nonpaying_cust_don
order by date

Output:


SQL Script:

USE [StrataScratch]
CREATE TABLE [dbo].[ms_acc_dimension](
	[acc_id] [int] NULL,
	[paying_customer] [varchar](50) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ms_download_facts](
	[date] [datetime] NULL,
	[user_id] [int] NULL,
	[downloads] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[ms_user_dimension](
	[user_id] [int] NULL,
	[acc_id] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (700, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (701, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (702, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (703, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (704, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (705, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (706, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (707, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (708, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (709, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (710, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (711, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (712, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (713, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (714, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (715, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (716, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (717, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (718, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (719, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (720, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (721, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (722, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (723, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (724, N'no')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (725, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (726, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (727, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (728, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (729, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (730, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (731, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (732, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (733, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (734, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (735, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (736, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (737, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (738, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (739, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (740, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (741, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (742, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (743, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (744, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (745, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (746, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (747, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (748, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (749, N'yes')
GO
INSERT [dbo].[ms_acc_dimension] ([acc_id], [paying_customer]) VALUES (750, N'yes')
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 1, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 2, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-18T00:00:00.000' AS DateTime), 3, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 4, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-19T00:00:00.000' AS DateTime), 5, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 6, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 7, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 8, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 9, 5)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-16T00:00:00.000' AS DateTime), 10, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 11, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-19T00:00:00.000' AS DateTime), 12, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-15T00:00:00.000' AS DateTime), 13, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 14, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 15, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-15T00:00:00.000' AS DateTime), 16, 5)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-18T00:00:00.000' AS DateTime), 17, 5)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-23T00:00:00.000' AS DateTime), 18, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-15T00:00:00.000' AS DateTime), 19, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 20, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-16T00:00:00.000' AS DateTime), 21, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 22, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 23, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 24, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 25, 5)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-23T00:00:00.000' AS DateTime), 26, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-19T00:00:00.000' AS DateTime), 27, 9)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 28, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 29, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 30, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 31, 5)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 32, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-15T00:00:00.000' AS DateTime), 33, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 34, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 35, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 36, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 37, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-16T00:00:00.000' AS DateTime), 38, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 39, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 40, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-18T00:00:00.000' AS DateTime), 41, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-16T00:00:00.000' AS DateTime), 42, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-23T00:00:00.000' AS DateTime), 43, 9)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 44, 9)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-16T00:00:00.000' AS DateTime), 45, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-15T00:00:00.000' AS DateTime), 46, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 47, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 48, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 49, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 50, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 51, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 52, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-16T00:00:00.000' AS DateTime), 53, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 54, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 55, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 56, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-18T00:00:00.000' AS DateTime), 57, 5)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 58, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 59, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 60, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 61, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-15T00:00:00.000' AS DateTime), 62, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-23T00:00:00.000' AS DateTime), 63, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 64, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-16T00:00:00.000' AS DateTime), 65, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-16T00:00:00.000' AS DateTime), 66, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-19T00:00:00.000' AS DateTime), 67, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-18T00:00:00.000' AS DateTime), 68, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 69, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 70, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 71, 6)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-15T00:00:00.000' AS DateTime), 72, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 73, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 74, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 75, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-19T00:00:00.000' AS DateTime), 76, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 77, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 78, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 79, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-23T00:00:00.000' AS DateTime), 80, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 81, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 82, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 83, 4)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 84, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 85, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 86, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-20T00:00:00.000' AS DateTime), 87, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-19T00:00:00.000' AS DateTime), 88, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 89, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 90, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-22T00:00:00.000' AS DateTime), 91, 9)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 92, 7)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 93, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-17T00:00:00.000' AS DateTime), 94, 1)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-23T00:00:00.000' AS DateTime), 95, 2)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 96, 3)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 97, 8)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-24T00:00:00.000' AS DateTime), 98, 0)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-21T00:00:00.000' AS DateTime), 99, 9)
GO
INSERT [dbo].[ms_download_facts] ([date], [user_id], [downloads]) VALUES (CAST(N'2020-08-25T00:00:00.000' AS DateTime), 100, 7)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (1, 716)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (2, 749)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (3, 713)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (4, 744)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (5, 726)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (6, 706)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (7, 750)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (8, 732)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (9, 706)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (10, 729)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (11, 748)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (12, 731)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (13, 739)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (14, 740)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (15, 705)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (16, 706)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (17, 701)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (18, 746)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (19, 726)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (20, 748)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (21, 701)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (22, 707)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (23, 710)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (24, 702)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (25, 720)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (26, 730)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (27, 721)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (28, 733)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (29, 732)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (30, 729)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (31, 716)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (32, 722)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (33, 745)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (34, 737)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (35, 730)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (36, 729)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (37, 723)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (38, 710)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (39, 707)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (40, 737)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (41, 717)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (42, 741)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (43, 718)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (44, 736)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (45, 720)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (46, 743)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (47, 707)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (48, 721)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (49, 748)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (50, 715)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (51, 709)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (52, 732)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (53, 732)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (54, 712)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (55, 701)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (56, 721)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (57, 744)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (58, 724)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (59, 727)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (60, 743)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (61, 744)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (62, 717)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (63, 723)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (64, 713)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (65, 706)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (66, 731)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (67, 722)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (68, 744)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (69, 705)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (70, 703)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (71, 725)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (72, 740)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (73, 713)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (74, 732)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (75, 720)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (76, 709)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (77, 739)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (78, 703)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (79, 732)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (80, 728)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (81, 737)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (82, 711)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (83, 745)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (84, 734)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (85, 723)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (86, 718)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (87, 702)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (88, 718)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (89, 744)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (90, 710)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (91, 727)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (92, 739)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (93, 728)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (94, 740)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (95, 744)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (96, 737)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (97, 726)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (98, 722)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (99, 727)
GO
INSERT [dbo].[ms_user_dimension] ([user_id], [acc_id]) VALUES (100, 712)
GO


Comments (0)
Questions List