SQL Query Solutions

#2031

Get list of signups which have a transaction start date earlier than 10 months ago from March 2021. For all of those users get the average transaction value and group it by the billing cycle.

Your output should include the billing cycle, signup_id of the user, and average transaction amount. Sort your results by billing cycle in reverse alphabetical order and signup_id in ascending order.

table name: signups

table name: transactions

table name: plans

Solution:

select p.billing_cycle, s.signup_id, avg(t.amt) as avgAmt
from signups as s
join transactions as t on s.signup_id = t.signup_id
join plans as p on s.plan_id = p.id
where t.transaction_start_date  < dateadd(MONTH,-10,'2021-03-01')
group by p.billing_cycle ,s.signup_id
order by p.billing_cycle desc, s.signup_id asc

Output:

SQL Script:

USE [StrataScratch]
GO
/****** Object:  Table [dbo].[plans]    Script Date: 14-01-2024 20:47:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[plans](
	[id] [int] NULL,
	[billing_cycle] [varchar](50) NULL,
	[avg_revenue] [float] NULL,
	[currency] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[signups]    Script Date: 14-01-2024 20:47:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[signups](
	[signup_id] [int] NULL,
	[signup_start_date] [datetime] NULL,
	[signup_stop_date] [datetime] NULL,
	[plan_id] [int] NULL,
	[location] [varchar](50) NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[transactions]    Script Date: 14-01-2024 20:47:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[transactions](
	[transaction_id] [int] NULL,
	[signup_id] [int] NULL,
	[transaction_start_date] [datetime] NULL,
	[amt] [float] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[plans] ([id], [billing_cycle], [avg_revenue], [currency]) VALUES (10, N'monthly', 9.9, N'USD')
GO
INSERT [dbo].[plans] ([id], [billing_cycle], [avg_revenue], [currency]) VALUES (11, N'quarterly', 24.9, N'USD')
GO
INSERT [dbo].[plans] ([id], [billing_cycle], [avg_revenue], [currency]) VALUES (12, N'annual', 109.9, N'USD')
GO
INSERT [dbo].[plans] ([id], [billing_cycle], [avg_revenue], [currency]) VALUES (20, N'monthly', 9.9, N'USD')
GO
INSERT [dbo].[plans] ([id], [billing_cycle], [avg_revenue], [currency]) VALUES (21, N'quarterly', 24.9, N'USD')
GO
INSERT [dbo].[plans] ([id], [billing_cycle], [avg_revenue], [currency]) VALUES (22, N'annual', 109.9, N'USD')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (100, CAST(N'2020-04-23T00:00:00.000' AS DateTime), CAST(N'2020-05-19T00:00:00.000' AS DateTime), 11, N'Rio De Janeiro')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (101, CAST(N'2020-04-09T00:00:00.000' AS DateTime), CAST(N'2020-07-06T00:00:00.000' AS DateTime), 11, N'Mexico City')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (102, CAST(N'2020-04-21T00:00:00.000' AS DateTime), CAST(N'2020-10-08T00:00:00.000' AS DateTime), 10, N'Mendoza')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (103, CAST(N'2020-04-04T00:00:00.000' AS DateTime), CAST(N'2020-06-19T00:00:00.000' AS DateTime), 11, N'Rio De Janeiro')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (104, CAST(N'2020-04-24T00:00:00.000' AS DateTime), CAST(N'2020-06-28T00:00:00.000' AS DateTime), 21, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (105, CAST(N'2020-04-14T00:00:00.000' AS DateTime), CAST(N'2020-07-15T00:00:00.000' AS DateTime), 20, N'Rio De Janeiro')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (106, CAST(N'2020-04-10T00:00:00.000' AS DateTime), CAST(N'2020-07-29T00:00:00.000' AS DateTime), 22, N'Mexico City')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (107, CAST(N'2020-04-07T00:00:00.000' AS DateTime), CAST(N'2020-08-26T00:00:00.000' AS DateTime), 12, N'Mexico City')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (108, CAST(N'2020-04-21T00:00:00.000' AS DateTime), CAST(N'2020-05-31T00:00:00.000' AS DateTime), 10, N'New Jersey')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (109, CAST(N'2020-04-11T00:00:00.000' AS DateTime), CAST(N'2020-09-17T00:00:00.000' AS DateTime), 21, N'Mendoza')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (110, CAST(N'2020-04-15T00:00:00.000' AS DateTime), CAST(N'2020-05-08T00:00:00.000' AS DateTime), 11, N'Houston')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (111, CAST(N'2020-04-04T00:00:00.000' AS DateTime), CAST(N'2020-09-03T00:00:00.000' AS DateTime), 12, N'New Jersey')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (112, CAST(N'2020-04-15T00:00:00.000' AS DateTime), CAST(N'2020-08-31T00:00:00.000' AS DateTime), 20, N'New York')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (113, CAST(N'2020-04-22T00:00:00.000' AS DateTime), CAST(N'2020-06-29T00:00:00.000' AS DateTime), 22, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (114, CAST(N'2020-04-20T00:00:00.000' AS DateTime), CAST(N'2020-06-21T00:00:00.000' AS DateTime), 11, N'Houston')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (115, CAST(N'2020-04-28T00:00:00.000' AS DateTime), CAST(N'2020-09-25T00:00:00.000' AS DateTime), 21, N'Luxembourg')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (116, CAST(N'2020-04-17T00:00:00.000' AS DateTime), CAST(N'2020-09-26T00:00:00.000' AS DateTime), 11, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (117, CAST(N'2020-04-22T00:00:00.000' AS DateTime), CAST(N'2020-06-30T00:00:00.000' AS DateTime), 22, N'New Jersey')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (118, CAST(N'2020-04-04T00:00:00.000' AS DateTime), CAST(N'2020-05-28T00:00:00.000' AS DateTime), 12, N'Rio De Janeiro')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (119, CAST(N'2020-04-21T00:00:00.000' AS DateTime), CAST(N'2020-08-13T00:00:00.000' AS DateTime), 11, N'New York')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (120, CAST(N'2020-04-10T00:00:00.000' AS DateTime), CAST(N'2020-05-16T00:00:00.000' AS DateTime), 11, N'Luxembourg')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (121, CAST(N'2020-04-22T00:00:00.000' AS DateTime), CAST(N'2020-08-13T00:00:00.000' AS DateTime), 22, N'Mexico City')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (122, CAST(N'2020-04-13T00:00:00.000' AS DateTime), CAST(N'2020-06-12T00:00:00.000' AS DateTime), 20, N'Houston')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (123, CAST(N'2020-04-13T00:00:00.000' AS DateTime), CAST(N'2020-10-09T00:00:00.000' AS DateTime), 10, N'Luxembourg')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (124, CAST(N'2020-04-18T00:00:00.000' AS DateTime), CAST(N'2020-06-03T00:00:00.000' AS DateTime), 11, N'New York')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (125, CAST(N'2020-04-16T00:00:00.000' AS DateTime), CAST(N'2020-06-15T00:00:00.000' AS DateTime), 10, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (126, CAST(N'2020-04-21T00:00:00.000' AS DateTime), CAST(N'2020-07-25T00:00:00.000' AS DateTime), 21, N'Rio De Janeiro')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (127, CAST(N'2020-04-24T00:00:00.000' AS DateTime), CAST(N'2020-09-22T00:00:00.000' AS DateTime), 21, N'Mendoza')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (128, CAST(N'2020-04-27T00:00:00.000' AS DateTime), CAST(N'2020-08-03T00:00:00.000' AS DateTime), 20, N'Houston')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (129, CAST(N'2020-04-04T00:00:00.000' AS DateTime), CAST(N'2020-04-30T00:00:00.000' AS DateTime), 12, N'Mendoza')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (130, CAST(N'2020-04-07T00:00:00.000' AS DateTime), CAST(N'2020-08-14T00:00:00.000' AS DateTime), 22, N'Mexico City')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (131, CAST(N'2020-04-22T00:00:00.000' AS DateTime), CAST(N'2020-06-22T00:00:00.000' AS DateTime), 11, N'Mendoza')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (132, CAST(N'2020-04-06T00:00:00.000' AS DateTime), CAST(N'2020-09-19T00:00:00.000' AS DateTime), 10, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (133, CAST(N'2020-04-15T00:00:00.000' AS DateTime), CAST(N'2020-06-13T00:00:00.000' AS DateTime), 20, N'Houston')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (134, CAST(N'2020-04-29T00:00:00.000' AS DateTime), CAST(N'2020-05-28T00:00:00.000' AS DateTime), 21, N'New York')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (135, CAST(N'2020-04-18T00:00:00.000' AS DateTime), CAST(N'2020-10-04T00:00:00.000' AS DateTime), 21, N'New Jersey')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (136, CAST(N'2020-04-28T00:00:00.000' AS DateTime), CAST(N'2020-06-22T00:00:00.000' AS DateTime), 11, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (137, CAST(N'2020-04-15T00:00:00.000' AS DateTime), CAST(N'2020-07-13T00:00:00.000' AS DateTime), 20, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (138, CAST(N'2020-04-24T00:00:00.000' AS DateTime), CAST(N'2020-10-02T00:00:00.000' AS DateTime), 11, N'New Jersey')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (139, CAST(N'2020-04-28T00:00:00.000' AS DateTime), CAST(N'2020-10-06T00:00:00.000' AS DateTime), 21, N'Houston')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (140, CAST(N'2020-04-17T00:00:00.000' AS DateTime), CAST(N'2020-09-10T00:00:00.000' AS DateTime), 11, N'Houston')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (141, CAST(N'2020-04-27T00:00:00.000' AS DateTime), CAST(N'2020-09-29T00:00:00.000' AS DateTime), 10, N'New Jersey')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (142, CAST(N'2020-04-09T00:00:00.000' AS DateTime), CAST(N'2020-06-24T00:00:00.000' AS DateTime), 11, N'Luxembourg')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (143, CAST(N'2020-04-29T00:00:00.000' AS DateTime), CAST(N'2020-10-16T00:00:00.000' AS DateTime), 21, N'New York')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (144, CAST(N'2020-04-13T00:00:00.000' AS DateTime), CAST(N'2020-06-21T00:00:00.000' AS DateTime), 12, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (145, CAST(N'2020-04-29T00:00:00.000' AS DateTime), CAST(N'2020-07-15T00:00:00.000' AS DateTime), 11, N'Luxembourg')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (146, CAST(N'2020-04-25T00:00:00.000' AS DateTime), CAST(N'2020-06-21T00:00:00.000' AS DateTime), 12, N'Houston')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (147, CAST(N'2020-04-24T00:00:00.000' AS DateTime), CAST(N'2020-08-18T00:00:00.000' AS DateTime), 21, N'Las Vegas')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (148, CAST(N'2020-04-29T00:00:00.000' AS DateTime), CAST(N'2020-10-07T00:00:00.000' AS DateTime), 20, N'Mexico City')
GO
INSERT [dbo].[signups] ([signup_id], [signup_start_date], [signup_stop_date], [plan_id], [location]) VALUES (149, CAST(N'2020-04-28T00:00:00.000' AS DateTime), CAST(N'2020-09-23T00:00:00.000' AS DateTime), 12, N'Rio De Janeiro')
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (1, 100, CAST(N'2020-04-30T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (2, 101, CAST(N'2020-04-16T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (3, 102, CAST(N'2020-04-28T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (4, 102, CAST(N'2020-05-28T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (5, 102, CAST(N'2020-06-27T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (6, 102, CAST(N'2020-07-27T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (7, 102, CAST(N'2020-08-26T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (8, 102, CAST(N'2020-09-25T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (9, 103, CAST(N'2020-04-11T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (10, 104, CAST(N'2020-05-01T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (11, 105, CAST(N'2020-04-21T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (12, 105, CAST(N'2020-05-21T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (13, 105, CAST(N'2020-06-20T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (14, 106, CAST(N'2020-04-17T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (15, 107, CAST(N'2020-04-14T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (16, 108, CAST(N'2020-04-28T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (17, 108, CAST(N'2020-05-28T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (18, 109, CAST(N'2020-04-18T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (19, 109, CAST(N'2020-07-17T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (20, 110, CAST(N'2020-04-22T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (21, 111, CAST(N'2020-04-11T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (22, 112, CAST(N'2020-04-22T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (23, 112, CAST(N'2020-05-22T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (24, 112, CAST(N'2020-06-21T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (25, 112, CAST(N'2020-07-21T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (26, 112, CAST(N'2020-08-20T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (27, 113, CAST(N'2020-04-29T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (28, 114, CAST(N'2020-04-27T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (29, 115, CAST(N'2020-05-05T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (30, 115, CAST(N'2020-08-03T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (31, 116, CAST(N'2020-04-24T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (32, 116, CAST(N'2020-07-23T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (33, 117, CAST(N'2020-04-29T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (34, 118, CAST(N'2020-04-11T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (35, 119, CAST(N'2020-04-28T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (36, 119, CAST(N'2020-07-27T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (37, 120, CAST(N'2020-04-17T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (38, 121, CAST(N'2020-04-29T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (39, 122, CAST(N'2020-04-20T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (40, 122, CAST(N'2020-05-20T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (41, 123, CAST(N'2020-04-20T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (42, 123, CAST(N'2020-05-20T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (43, 123, CAST(N'2020-06-19T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (44, 123, CAST(N'2020-07-19T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (45, 123, CAST(N'2020-08-18T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (46, 123, CAST(N'2020-09-17T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (47, 124, CAST(N'2020-04-25T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (48, 125, CAST(N'2020-04-23T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (49, 125, CAST(N'2020-05-23T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (50, 126, CAST(N'2020-04-28T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (51, 127, CAST(N'2020-05-01T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (52, 127, CAST(N'2020-07-30T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (53, 128, CAST(N'2020-05-04T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (54, 128, CAST(N'2020-06-03T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (55, 128, CAST(N'2020-07-03T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (56, 128, CAST(N'2020-08-02T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (57, 129, CAST(N'2020-04-11T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (58, 130, CAST(N'2020-04-14T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (59, 131, CAST(N'2020-04-29T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (60, 132, CAST(N'2020-04-13T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (61, 132, CAST(N'2020-05-13T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (62, 132, CAST(N'2020-06-12T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (63, 132, CAST(N'2020-07-12T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (64, 132, CAST(N'2020-08-11T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (65, 132, CAST(N'2020-09-10T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (66, 133, CAST(N'2020-04-22T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (67, 133, CAST(N'2020-05-22T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (68, 134, CAST(N'2020-05-06T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (69, 135, CAST(N'2020-04-25T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (70, 135, CAST(N'2020-07-24T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (71, 136, CAST(N'2020-05-05T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (72, 137, CAST(N'2020-04-22T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (73, 137, CAST(N'2020-05-22T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (74, 137, CAST(N'2020-06-21T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (75, 138, CAST(N'2020-05-01T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (76, 138, CAST(N'2020-07-30T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (77, 139, CAST(N'2020-05-05T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (78, 139, CAST(N'2020-08-03T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (79, 140, CAST(N'2020-04-24T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (80, 140, CAST(N'2020-07-23T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (81, 141, CAST(N'2020-05-04T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (82, 141, CAST(N'2020-06-03T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (83, 141, CAST(N'2020-07-03T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (84, 141, CAST(N'2020-08-02T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (85, 141, CAST(N'2020-09-01T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (86, 142, CAST(N'2020-04-16T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (87, 143, CAST(N'2020-05-06T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (88, 143, CAST(N'2020-08-04T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (89, 144, CAST(N'2020-04-20T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (90, 145, CAST(N'2020-05-06T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (91, 146, CAST(N'2020-05-02T00:00:00.000' AS DateTime), 109.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (92, 147, CAST(N'2020-05-01T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (93, 147, CAST(N'2020-07-30T00:00:00.000' AS DateTime), 24.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (94, 148, CAST(N'2020-05-06T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (95, 148, CAST(N'2020-06-05T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (96, 148, CAST(N'2020-07-05T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (97, 148, CAST(N'2020-08-04T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (98, 148, CAST(N'2020-09-03T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (99, 148, CAST(N'2020-10-03T00:00:00.000' AS DateTime), 9.9)
GO
INSERT [dbo].[transactions] ([transaction_id], [signup_id], [transaction_start_date], [amt]) VALUES (100, 149, CAST(N'2020-05-05T00:00:00.000' AS DateTime), 109.9)
GO

Comments (0)

Transactions By Billing Method and Signup ID

Income By Title and Gender

Employee and Manager Salaries

Highest Energy Consumption

Highest Target Under Manager

Top Businesses With Most Reviews

Workers With The Highest Salaries

Find the top 10 ranked songs in 2010

Requests Acceptance Rate

Find the top five hotels with the highest total reviews given by a particular reviewer

Algorithm Performance

New Products

Expensive Projects

Most Active Users On Messenger

Find the top-ranked songs for the past 20 years

Find the lowest score for each facility in Hollywood Boulevard

Ranking Hosts By Beds

Find the percentage of shipable orders

Rows With Missing Values

Spam Posts

Number of Speakers By Language

Find the total number of approved friendship requests in January and February

Inspections Per Risk Category

Number of Conversations

Cheapest Neighborhood With Real Beds And Internet

Homework Results

Acceptance Rate By Date

Distances Traveled

Least Popular Video

Flags per Video

Manager of the Largest Department

Users Exclusive Per Client

Rush Hour Calls

Top 2 Users With Most Calls

Initial Call Duration

Variable vs Fixed Rates

Same Brand Purchases

Share of Active Users

Update Call Duration

Highest Total Miles

Find the total number of available beds per hosts' nationality

Product Transaction Count

Best Wines By Points-To-Price

Find the number of wines each taster tasted within the variation

Athletes On Single Or Multiple Teams

Average Weight of Medal-Winning Judo

European Olympics

Find all inspections which are part of an inactive program

Wine Variety Revenues

Number Of Custom Email Labels

Requests Acceptance Rate

Email Details Based On Sends

Meta/Facebook Matching Users Pairs

Find the number of customers without an order

Liked' Posts

Customers Who Purchased the Same Product

Sum Of Numbers

Overtime Pay

Highest And Lowest Paying Jobs

Highest Target

Employee with Most Orders

Class Performance

Apple Product Counts

Cities With The Most Expensive Homes

Top Streamers

Share of Loan Balance

User Email Labels

Transactions By Billing Method and Signup ID

MacBook Pro Events

Sales Evaluation on Media Formats

Customer Feedback Analysis

Find all number pairs whose first number is smaller than the second one and the product of two numbers is larger than 11

Highest Cost Orders

Largest Olympics

Number Of Units Per Nationality

Number of violations

Classify Business Type

Find the rate of processed tickets for each type

Highest Salary In Department

Customer Revenue In March