Users Exclusive Per Client

Write a query that returns a number of users who are exclusive to only one client. Output the client_id and number of exclusive users.

table name: fact_events


Solution:

select client_id,count(distinct user_id) as noOfUsers
from fact_events where 
user_id in(
select user_id
from fact_events
group by user_id
having count(distinct client_id)=1
)
group by client_id

Output:


SQL Script:

USE [StrataScratch]
GO
CREATE TABLE [dbo].[fact_events](
	[id] [int] NULL,
	[time_id] [datetime] NULL,
	[user_id] [varchar](50) NULL,
	[customer_id] [varchar](50) NULL,
	[client_id] [varchar](50) NULL,
	[event_type] [varchar](50) NULL,
	[event_id] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (1, CAST(N'2020-02-28T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Sendit', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (2, CAST(N'2020-02-28T00:00:00.000' AS DateTime), N'7892-POOKP', N'Connectix', N'mobile', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (3, CAST(N'2020-04-03T00:00:00.000' AS DateTime), N'9763-GRSKD', N'Zoomit', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (4, CAST(N'2020-04-02T00:00:00.000' AS DateTime), N'9763-GRSKD', N'Connectix', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (5, CAST(N'2020-02-06T00:00:00.000' AS DateTime), N'9237-HQITU', N'Sendit', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (6, CAST(N'2020-02-27T00:00:00.000' AS DateTime), N'8191-XWSZG', N'Connectix', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (7, CAST(N'2020-04-03T00:00:00.000' AS DateTime), N'9237-HQITU', N'Connectix', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (8, CAST(N'2020-03-01T00:00:00.000' AS DateTime), N'9237-HQITU', N'Connectix', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (9, CAST(N'2020-04-02T00:00:00.000' AS DateTime), N'4190-MFLUW', N'Connectix', N'mobile', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (10, CAST(N'2020-04-21T00:00:00.000' AS DateTime), N'9763-GRSKD', N'Sendit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (11, CAST(N'2020-02-28T00:00:00.000' AS DateTime), N'5129-JLPIS', N'Electric Gravity', N'mobile', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (12, CAST(N'2020-03-31T00:00:00.000' AS DateTime), N'6713-OKOMC', N'Connectix', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (13, CAST(N'2020-03-21T00:00:00.000' AS DateTime), N'6388-TABGU', N'Connectix', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (14, CAST(N'2020-03-03T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Connectix', N'mobile', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (15, CAST(N'2020-02-11T00:00:00.000' AS DateTime), N'9237-HQITU', N'Connectix', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (16, CAST(N'2020-03-01T00:00:00.000' AS DateTime), N'5575-GNVDE', N'Zoomit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (17, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'6388-TABGU', N'Connectix', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (18, CAST(N'2020-04-06T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (19, CAST(N'2020-02-13T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Connectix', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (20, CAST(N'2020-04-03T00:00:00.000' AS DateTime), N'9959-WOFKT', N'Connectix', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (21, CAST(N'2020-03-15T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Zoomit', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (22, CAST(N'2020-04-01T00:00:00.000' AS DateTime), N'7892-POOKP', N'eShop', N'mobile', N'voice call started', 8)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (23, CAST(N'2020-04-09T00:00:00.000' AS DateTime), N'8191-XWSZG', N'Connectix', N'mobile', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (24, CAST(N'2020-04-08T00:00:00.000' AS DateTime), N'3668-QPYBK', N'eShop', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (25, CAST(N'2020-03-05T00:00:00.000' AS DateTime), N'8191-XWSZG', N'Zoomit', N'mobile', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (26, CAST(N'2020-02-24T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Connectix', N'mobile', N'api message received', 5)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (27, CAST(N'2020-03-26T00:00:00.000' AS DateTime), N'6388-TABGU', N'Zoomit', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (28, CAST(N'2020-02-03T00:00:00.000' AS DateTime), N'7795-CFOCW', N'Connectix', N'mobile', N'api message received', 5)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (29, CAST(N'2020-03-19T00:00:00.000' AS DateTime), N'7892-POOKP', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (30, CAST(N'2020-04-07T00:00:00.000' AS DateTime), N'9763-GRSKD', N'Connectix', N'mobile', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (31, CAST(N'2020-04-06T00:00:00.000' AS DateTime), N'9959-WOFKT', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (32, CAST(N'2020-02-15T00:00:00.000' AS DateTime), N'9237-HQITU', N'Connectix', N'mobile', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (33, CAST(N'2020-04-06T00:00:00.000' AS DateTime), N'4183-MYFRB', N'Sendit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (34, CAST(N'2020-03-13T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Connectix', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (35, CAST(N'2020-04-05T00:00:00.000' AS DateTime), N'9959-WOFKT', N'Connectix', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (36, CAST(N'2020-03-28T00:00:00.000' AS DateTime), N'6388-TABGU', N'Connectix', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (37, CAST(N'2020-04-03T00:00:00.000' AS DateTime), N'4183-MYFRB', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (38, CAST(N'2020-03-15T00:00:00.000' AS DateTime), N'5575-GNVDE', N'Electric Gravity', N'desktop', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (39, CAST(N'2020-03-06T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Zoomit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (40, CAST(N'2020-03-25T00:00:00.000' AS DateTime), N'4190-MFLUW', N'Connectix', N'mobile', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (41, CAST(N'2020-04-13T00:00:00.000' AS DateTime), N'9959-WOFKT', N'Zoomit', N'mobile', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (42, CAST(N'2020-02-20T00:00:00.000' AS DateTime), N'7590-VHVEG', N'Sendit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (43, CAST(N'2020-03-13T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Connectix', N'mobile', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (44, CAST(N'2020-02-22T00:00:00.000' AS DateTime), N'1452-KIOVK', N'Zoomit', N'mobile', N'voice call started', 8)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (45, CAST(N'2020-04-18T00:00:00.000' AS DateTime), N'9959-WOFKT', N'Connectix', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (46, CAST(N'2020-02-04T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Connectix', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (47, CAST(N'2020-04-06T00:00:00.000' AS DateTime), N'4190-MFLUW', N'Connectix', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (48, CAST(N'2020-03-22T00:00:00.000' AS DateTime), N'1452-KIOVK', N'Connectix', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (49, CAST(N'2020-04-06T00:00:00.000' AS DateTime), N'5129-JLPIS', N'Sendit', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (50, CAST(N'2020-04-04T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Sendit', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (51, CAST(N'2020-02-14T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (52, CAST(N'2020-03-28T00:00:00.000' AS DateTime), N'5575-GNVDE', N'Sendit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (53, CAST(N'2020-04-05T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Connectix', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (54, CAST(N'2020-03-01T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Connectix', N'desktop', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (55, CAST(N'2020-02-20T00:00:00.000' AS DateTime), N'5129-JLPIS', N'Connectix', N'desktop', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (56, CAST(N'2020-03-13T00:00:00.000' AS DateTime), N'7590-VHVEG', N'Zoomit', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (57, CAST(N'2020-04-09T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Sendit', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (58, CAST(N'2020-02-27T00:00:00.000' AS DateTime), N'9237-HQITU', N'eShop', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (59, CAST(N'2020-03-24T00:00:00.000' AS DateTime), N'8191-XWSZG', N'Connectix', N'mobile', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (60, CAST(N'2020-03-19T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Sendit', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (61, CAST(N'2020-03-29T00:00:00.000' AS DateTime), N'7892-POOKP', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (62, CAST(N'2020-03-14T00:00:00.000' AS DateTime), N'5129-JLPIS', N'Connectix', N'mobile', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (63, CAST(N'2020-03-07T00:00:00.000' AS DateTime), N'4190-MFLUW', N'Electric Gravity', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (64, CAST(N'2020-03-05T00:00:00.000' AS DateTime), N'4190-MFLUW', N'Connectix', N'desktop', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (65, CAST(N'2020-02-06T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Sendit', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (66, CAST(N'2020-02-08T00:00:00.000' AS DateTime), N'6713-OKOMC', N'Connectix', N'desktop', N'voice call started', 8)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (67, CAST(N'2020-02-24T00:00:00.000' AS DateTime), N'6713-OKOMC', N'Connectix', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (68, CAST(N'2020-03-25T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Connectix', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (69, CAST(N'2020-02-12T00:00:00.000' AS DateTime), N'1452-KIOVK', N'Connectix', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (70, CAST(N'2020-02-08T00:00:00.000' AS DateTime), N'7795-CFOCW', N'Connectix', N'desktop', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (71, CAST(N'2020-03-10T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Connectix', N'mobile', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (72, CAST(N'2020-03-09T00:00:00.000' AS DateTime), N'9237-HQITU', N'Sendit', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (73, CAST(N'2020-03-13T00:00:00.000' AS DateTime), N'5575-GNVDE', N'Sendit', N'mobile', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (74, CAST(N'2020-03-17T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Electric Gravity', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (75, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'4190-MFLUW', N'Sendit', N'mobile', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (76, CAST(N'2020-04-09T00:00:00.000' AS DateTime), N'7892-POOKP', N'Sendit', N'desktop', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (77, CAST(N'2020-03-18T00:00:00.000' AS DateTime), N'7590-VHVEG', N'Sendit', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (78, CAST(N'2020-02-27T00:00:00.000' AS DateTime), N'3655-SNQYZ', N'Sendit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (79, CAST(N'2020-02-03T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Zoomit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (80, CAST(N'2020-02-03T00:00:00.000' AS DateTime), N'0280-XJGEX', N'eShop', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (81, CAST(N'2020-02-25T00:00:00.000' AS DateTime), N'6713-OKOMC', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (82, CAST(N'2020-02-19T00:00:00.000' AS DateTime), N'6713-OKOMC', N'Connectix', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (83, CAST(N'2020-03-26T00:00:00.000' AS DateTime), N'7590-VHVEG', N'Electric Gravity', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (84, CAST(N'2020-03-19T00:00:00.000' AS DateTime), N'8091-TTVAX', N'eShop', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (85, CAST(N'2020-02-17T00:00:00.000' AS DateTime), N'9237-HQITU', N'Connectix', N'desktop', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (86, CAST(N'2020-03-14T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Sendit', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (87, CAST(N'2020-02-17T00:00:00.000' AS DateTime), N'8191-XWSZG', N'Connectix', N'mobile', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (88, CAST(N'2020-02-13T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Sendit', N'desktop', N'voice call started', 8)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (89, CAST(N'2020-04-01T00:00:00.000' AS DateTime), N'9959-WOFKT', N'Connectix', N'mobile', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (90, CAST(N'2020-03-26T00:00:00.000' AS DateTime), N'7795-CFOCW', N'Sendit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (91, CAST(N'2020-04-08T00:00:00.000' AS DateTime), N'7795-CFOCW', N'Zoomit', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (92, CAST(N'2020-03-28T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Connectix', N'desktop', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (93, CAST(N'2020-03-06T00:00:00.000' AS DateTime), N'6713-OKOMC', N'Connectix', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (94, CAST(N'2020-02-23T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Sendit', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (95, CAST(N'2020-03-19T00:00:00.000' AS DateTime), N'5575-GNVDE', N'Sendit', N'desktop', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (96, CAST(N'2020-03-28T00:00:00.000' AS DateTime), N'3668-QPYBK', N'eShop', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (97, CAST(N'2020-03-22T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Connectix', N'mobile', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (98, CAST(N'2020-02-09T00:00:00.000' AS DateTime), N'3655-SNQYZ', N'Connectix', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (99, CAST(N'2020-03-18T00:00:00.000' AS DateTime), N'6388-TABGU', N'Sendit', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (100, CAST(N'2020-03-31T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Sendit', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (101, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'5129-JLPIS', N'Sendit', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (102, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'9237-HQITU', N'Connectix', N'desktop', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (103, CAST(N'2020-03-01T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (104, CAST(N'2020-04-07T00:00:00.000' AS DateTime), N'5575-GNVDE', N'Connectix', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (105, CAST(N'2020-02-17T00:00:00.000' AS DateTime), N'8191-XWSZG', N'Zoomit', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (106, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'0280-XJGEX', N'Electric Gravity', N'mobile', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (107, CAST(N'2020-02-07T00:00:00.000' AS DateTime), N'7590-VHVEG', N'eShop', N'mobile', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (108, CAST(N'2020-03-06T00:00:00.000' AS DateTime), N'7892-POOKP', N'Connectix', N'mobile', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (109, CAST(N'2020-02-03T00:00:00.000' AS DateTime), N'9237-HQITU', N'Sendit', N'mobile', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (110, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'1452-KIOVK', N'eShop', N'mobile', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (111, CAST(N'2020-02-04T00:00:00.000' AS DateTime), N'7892-POOKP', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (112, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'8191-XWSZG', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (113, CAST(N'2020-03-25T00:00:00.000' AS DateTime), N'4183-MYFRB', N'Sendit', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (114, CAST(N'2020-02-23T00:00:00.000' AS DateTime), N'6713-OKOMC', N'Connectix', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (115, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Sendit', N'desktop', N'voice call started', 8)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (116, CAST(N'2020-03-11T00:00:00.000' AS DateTime), N'7590-VHVEG', N'Sendit', N'desktop', N'api message received', 5)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (117, CAST(N'2020-04-08T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Zoomit', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (118, CAST(N'2020-02-01T00:00:00.000' AS DateTime), N'6713-OKOMC', N'Electric Gravity', N'mobile', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (119, CAST(N'2020-03-24T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Electric Gravity', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (120, CAST(N'2020-03-06T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Electric Gravity', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (121, CAST(N'2020-03-09T00:00:00.000' AS DateTime), N'5575-GNVDE', N'Connectix', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (122, CAST(N'2020-03-22T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Connectix', N'mobile', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (123, CAST(N'2020-03-02T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Connectix', N'mobile', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (124, CAST(N'2020-03-23T00:00:00.000' AS DateTime), N'5575-GNVDE', N'Connectix', N'mobile', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (125, CAST(N'2020-03-30T00:00:00.000' AS DateTime), N'9305-CDSKC', N'eShop', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (126, CAST(N'2020-03-25T00:00:00.000' AS DateTime), N'4190-MFLUW', N'Connectix', N'desktop', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (127, CAST(N'2020-03-09T00:00:00.000' AS DateTime), N'7590-VHVEG', N'Connectix', N'mobile', N'api message received', 5)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (128, CAST(N'2020-03-14T00:00:00.000' AS DateTime), N'7795-CFOCW', N'Sendit', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (129, CAST(N'2020-04-04T00:00:00.000' AS DateTime), N'9959-WOFKT', N'Connectix', N'mobile', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (130, CAST(N'2020-03-31T00:00:00.000' AS DateTime), N'5129-JLPIS', N'Connectix', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (131, CAST(N'2020-03-27T00:00:00.000' AS DateTime), N'4183-MYFRB', N'Connectix', N'desktop', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (132, CAST(N'2020-04-03T00:00:00.000' AS DateTime), N'5129-JLPIS', N'Connectix', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (133, CAST(N'2020-03-01T00:00:00.000' AS DateTime), N'0280-XJGEX', N'Connectix', N'desktop', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (134, CAST(N'2020-04-16T00:00:00.000' AS DateTime), N'9763-GRSKD', N'Connectix', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (135, CAST(N'2020-03-07T00:00:00.000' AS DateTime), N'6388-TABGU', N'Connectix', N'desktop', N'api message received', 5)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (136, CAST(N'2020-03-20T00:00:00.000' AS DateTime), N'9305-CDSKC', N'Zoomit', N'mobile', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (137, CAST(N'2020-03-10T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Sendit', N'desktop', N'video call started', 6)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (138, CAST(N'2020-03-20T00:00:00.000' AS DateTime), N'0280-XJGEX', N'Zoomit', N'mobile', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (139, CAST(N'2020-02-23T00:00:00.000' AS DateTime), N'5129-JLPIS', N'Connectix', N'mobile', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (140, CAST(N'2020-02-18T00:00:00.000' AS DateTime), N'7590-VHVEG', N'Connectix', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (141, CAST(N'2020-02-18T00:00:00.000' AS DateTime), N'1452-KIOVK', N'Connectix', N'mobile', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (142, CAST(N'2020-02-08T00:00:00.000' AS DateTime), N'3668-QPYBK', N'Sendit', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (143, CAST(N'2020-04-13T00:00:00.000' AS DateTime), N'7469-LKBCI', N'Sendit', N'desktop', N'video call received', 7)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (144, CAST(N'2020-03-22T00:00:00.000' AS DateTime), N'6388-TABGU', N'eShop', N'mobile', N'file sent', 1)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (145, CAST(N'2020-03-13T00:00:00.000' AS DateTime), N'0280-XJGEX', N'Sendit', N'desktop', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (146, CAST(N'2020-03-07T00:00:00.000' AS DateTime), N'6388-TABGU', N'Connectix', N'desktop', N'voice call received', 9)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (147, CAST(N'2020-03-21T00:00:00.000' AS DateTime), N'8091-TTVAX', N'Connectix', N'mobile', N'message sent', 3)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (148, CAST(N'2020-04-03T00:00:00.000' AS DateTime), N'8191-XWSZG', N'Connectix', N'desktop', N'file received', 2)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (149, CAST(N'2020-02-22T00:00:00.000' AS DateTime), N'7795-CFOCW', N'Connectix', N'desktop', N'message received', 4)
GO
INSERT [dbo].[fact_events] ([id], [time_id], [user_id], [customer_id], [client_id], [event_type], [event_id]) VALUES (150, CAST(N'2020-02-14T00:00:00.000' AS DateTime), N'7590-VHVEG', N'Connectix', N'desktop', N'message received', 4)
GO


Comments (0)
Questions List