#10017
Find how the number of drivers that have churned changed in each year compared to the previous one. Output the year (specifically, you can use the year the driver left Lyft) along with the corresponding number of churns in that year, the number of churns in the previous year, and an indication on whether the number has been increased (output the value 'increase'), decreased (output the value 'decrease') or stayed the same (output the value 'no change').
table name: lyft_drivers
Solution:
with cte as(
select count(l1.end_date) as churned, year(l1.end_date) as year1
from lyft_drivers as l1
where l1.end_date is not null
group by year(l1.end_date)) select c1.year1, c1.churned as this_year_churned, isnull(c2.churned,0) as perv_year_churned ,
case
when (c1.churned - isnull(c2.churned,0)) = 0 then 'no change'
when (c1.churned - isnull(c2.churned,0)) > 0 then 'increase'
when (c1.churned - isnull(c2.churned,0)) < 0 then 'decrease'
end as direction
from cte as c1
left join cte as c2 on c1.year1-1 = c2.year1
order by c1.year1 desc
Output:
SQL Script:
USE [StraScratch]
GO
/****** Object: Table [dbo].[lyft_drivers] Script Date: 26-09-2024 17:20:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[lyft_drivers](
[index] [int] NULL,
[start_date] [datetime] NULL,
[end_date] [datetime] NULL,
[yearly_salary] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (0, CAST(N'2018-04-02T00:00:00.000' AS DateTime), NULL, 48303)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (1, CAST(N'2018-05-30T00:00:00.000' AS DateTime), NULL, 67973)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (2, CAST(N'2015-04-05T00:00:00.000' AS DateTime), NULL, 56685)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (3, CAST(N'2015-01-08T00:00:00.000' AS DateTime), NULL, 51320)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (4, CAST(N'2017-03-09T00:00:00.000' AS DateTime), NULL, 67507)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (5, CAST(N'2015-09-07T00:00:00.000' AS DateTime), NULL, 55155)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (6, CAST(N'2016-05-22T00:00:00.000' AS DateTime), CAST(N'2018-08-06T00:00:00.000' AS DateTime), 35847)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (7, CAST(N'2015-09-29T00:00:00.000' AS DateTime), CAST(N'2018-07-20T00:00:00.000' AS DateTime), 46974)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (8, CAST(N'2015-09-15T00:00:00.000' AS DateTime), CAST(N'2019-04-30T00:00:00.000' AS DateTime), 54316)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (9, CAST(N'2015-09-20T00:00:00.000' AS DateTime), CAST(N'2017-12-31T00:00:00.000' AS DateTime), 56185)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (10, CAST(N'2018-04-25T00:00:00.000' AS DateTime), CAST(N'2018-04-28T00:00:00.000' AS DateTime), 79536)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (11, CAST(N'2017-12-10T00:00:00.000' AS DateTime), CAST(N'2018-10-03T00:00:00.000' AS DateTime), 56844)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (12, CAST(N'2017-11-16T00:00:00.000' AS DateTime), NULL, 41523)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (13, CAST(N'2016-09-15T00:00:00.000' AS DateTime), NULL, 38169)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (14, CAST(N'2015-11-30T00:00:00.000' AS DateTime), CAST(N'2018-04-24T00:00:00.000' AS DateTime), 89270)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (15, CAST(N'2018-05-29T00:00:00.000' AS DateTime), NULL, 87766)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (16, CAST(N'2015-05-17T00:00:00.000' AS DateTime), CAST(N'2017-02-08T00:00:00.000' AS DateTime), 64876)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (17, CAST(N'2017-05-07T00:00:00.000' AS DateTime), NULL, 88828)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (18, CAST(N'2018-11-09T00:00:00.000' AS DateTime), NULL, 82993)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (19, CAST(N'2015-10-26T00:00:00.000' AS DateTime), NULL, 58965)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (20, CAST(N'2015-04-23T00:00:00.000' AS DateTime), CAST(N'2017-01-30T00:00:00.000' AS DateTime), 71683)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (21, CAST(N'2015-01-18T00:00:00.000' AS DateTime), CAST(N'2015-05-26T00:00:00.000' AS DateTime), 68708)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (22, CAST(N'2016-12-25T00:00:00.000' AS DateTime), NULL, 85329)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (23, CAST(N'2015-05-11T00:00:00.000' AS DateTime), CAST(N'2018-03-29T00:00:00.000' AS DateTime), 72366)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (24, CAST(N'2018-03-24T00:00:00.000' AS DateTime), CAST(N'2019-01-04T00:00:00.000' AS DateTime), 84812)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (25, CAST(N'2018-02-26T00:00:00.000' AS DateTime), CAST(N'2018-08-11T00:00:00.000' AS DateTime), 67102)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (26, CAST(N'2016-05-12T00:00:00.000' AS DateTime), CAST(N'2018-10-02T00:00:00.000' AS DateTime), 88599)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (27, CAST(N'2017-03-26T00:00:00.000' AS DateTime), NULL, 85792)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (28, CAST(N'2018-03-15T00:00:00.000' AS DateTime), NULL, 63793)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (29, CAST(N'2016-03-30T00:00:00.000' AS DateTime), CAST(N'2018-08-10T00:00:00.000' AS DateTime), 29866)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (30, CAST(N'2018-03-13T00:00:00.000' AS DateTime), CAST(N'2019-01-29T00:00:00.000' AS DateTime), 50920)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (31, CAST(N'2016-11-01T00:00:00.000' AS DateTime), NULL, 82028)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (32, CAST(N'2016-05-10T00:00:00.000' AS DateTime), CAST(N'2018-05-14T00:00:00.000' AS DateTime), 42556)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (33, CAST(N'2016-06-17T00:00:00.000' AS DateTime), NULL, 39281)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (34, CAST(N'2018-07-01T00:00:00.000' AS DateTime), CAST(N'2019-01-19T00:00:00.000' AS DateTime), 59432)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (35, CAST(N'2018-10-19T00:00:00.000' AS DateTime), CAST(N'2018-11-23T00:00:00.000' AS DateTime), 90920)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (36, CAST(N'2015-03-09T00:00:00.000' AS DateTime), CAST(N'2015-10-07T00:00:00.000' AS DateTime), 57136)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (37, CAST(N'2018-09-01T00:00:00.000' AS DateTime), NULL, 43862)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (38, CAST(N'2017-03-15T00:00:00.000' AS DateTime), CAST(N'2019-03-20T00:00:00.000' AS DateTime), 41005)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (39, CAST(N'2015-07-24T00:00:00.000' AS DateTime), CAST(N'2016-09-23T00:00:00.000' AS DateTime), 30935)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (40, CAST(N'2017-07-06T00:00:00.000' AS DateTime), NULL, 34930)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (41, CAST(N'2017-06-27T00:00:00.000' AS DateTime), CAST(N'2017-12-29T00:00:00.000' AS DateTime), 90137)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (42, CAST(N'2015-07-31T00:00:00.000' AS DateTime), CAST(N'2016-10-03T00:00:00.000' AS DateTime), 47474)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (43, CAST(N'2018-02-01T00:00:00.000' AS DateTime), CAST(N'2018-06-12T00:00:00.000' AS DateTime), 39614)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (44, CAST(N'2018-04-08T00:00:00.000' AS DateTime), NULL, 50162)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (45, CAST(N'2018-04-08T00:00:00.000' AS DateTime), CAST(N'2018-06-27T00:00:00.000' AS DateTime), 63260)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (46, CAST(N'2018-01-17T00:00:00.000' AS DateTime), NULL, 66728)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (47, CAST(N'2018-06-12T00:00:00.000' AS DateTime), NULL, 76924)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (48, CAST(N'2015-09-17T00:00:00.000' AS DateTime), CAST(N'2017-10-05T00:00:00.000' AS DateTime), 43291)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (49, CAST(N'2015-10-06T00:00:00.000' AS DateTime), CAST(N'2016-11-27T00:00:00.000' AS DateTime), 27194)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (50, CAST(N'2018-12-08T00:00:00.000' AS DateTime), NULL, 48807)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (51, CAST(N'2015-04-24T00:00:00.000' AS DateTime), CAST(N'2015-12-24T00:00:00.000' AS DateTime), 36049)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (52, CAST(N'2015-12-23T00:00:00.000' AS DateTime), CAST(N'2017-02-17T00:00:00.000' AS DateTime), 69076)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (53, CAST(N'2016-02-10T00:00:00.000' AS DateTime), CAST(N'2016-08-20T00:00:00.000' AS DateTime), 38340)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (54, CAST(N'2017-09-16T00:00:00.000' AS DateTime), NULL, 42550)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (55, CAST(N'2016-12-02T00:00:00.000' AS DateTime), NULL, 29542)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (56, CAST(N'2017-11-20T00:00:00.000' AS DateTime), CAST(N'2018-01-08T00:00:00.000' AS DateTime), 31877)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (57, CAST(N'2017-08-24T00:00:00.000' AS DateTime), NULL, 42133)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (58, CAST(N'2015-12-01T00:00:00.000' AS DateTime), CAST(N'2017-11-04T00:00:00.000' AS DateTime), 35414)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (59, CAST(N'2017-06-14T00:00:00.000' AS DateTime), NULL, 31331)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (60, CAST(N'2017-01-23T00:00:00.000' AS DateTime), NULL, 64826)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (61, CAST(N'2018-10-21T00:00:00.000' AS DateTime), NULL, 31724)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (62, CAST(N'2017-08-24T00:00:00.000' AS DateTime), CAST(N'2019-01-27T00:00:00.000' AS DateTime), 74691)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (63, CAST(N'2018-07-02T00:00:00.000' AS DateTime), NULL, 75327)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (64, CAST(N'2015-08-03T00:00:00.000' AS DateTime), NULL, 26376)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (65, CAST(N'2015-04-25T00:00:00.000' AS DateTime), CAST(N'2018-01-15T00:00:00.000' AS DateTime), 29007)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (66, CAST(N'2015-02-15T00:00:00.000' AS DateTime), CAST(N'2018-12-28T00:00:00.000' AS DateTime), 60613)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (67, CAST(N'2016-10-05T00:00:00.000' AS DateTime), CAST(N'2018-12-04T00:00:00.000' AS DateTime), 51239)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (68, CAST(N'2018-07-22T00:00:00.000' AS DateTime), NULL, 88997)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (69, CAST(N'2017-02-10T00:00:00.000' AS DateTime), NULL, 64552)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (70, CAST(N'2015-02-26T00:00:00.000' AS DateTime), NULL, 65564)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (71, CAST(N'2017-08-03T00:00:00.000' AS DateTime), NULL, 85436)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (72, CAST(N'2016-01-09T00:00:00.000' AS DateTime), NULL, 72586)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (73, CAST(N'2018-02-14T00:00:00.000' AS DateTime), NULL, 85246)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (74, CAST(N'2018-08-12T00:00:00.000' AS DateTime), NULL, 56322)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (75, CAST(N'2018-11-04T00:00:00.000' AS DateTime), NULL, 91064)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (76, CAST(N'2015-02-08T00:00:00.000' AS DateTime), CAST(N'2015-12-15T00:00:00.000' AS DateTime), 83653)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (77, CAST(N'2017-04-05T00:00:00.000' AS DateTime), NULL, 52142)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (78, CAST(N'2018-06-20T00:00:00.000' AS DateTime), NULL, 49686)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (79, CAST(N'2016-10-18T00:00:00.000' AS DateTime), NULL, 77622)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (80, CAST(N'2017-12-13T00:00:00.000' AS DateTime), CAST(N'2018-11-29T00:00:00.000' AS DateTime), 71852)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (81, CAST(N'2016-09-20T00:00:00.000' AS DateTime), NULL, 62434)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (82, CAST(N'2018-01-29T00:00:00.000' AS DateTime), NULL, 35118)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (83, CAST(N'2017-11-18T00:00:00.000' AS DateTime), CAST(N'2018-11-03T00:00:00.000' AS DateTime), 60027)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (84, CAST(N'2017-08-03T00:00:00.000' AS DateTime), CAST(N'2018-07-17T00:00:00.000' AS DateTime), 65366)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (85, CAST(N'2016-10-07T00:00:00.000' AS DateTime), CAST(N'2018-10-19T00:00:00.000' AS DateTime), 36408)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (86, CAST(N'2018-03-30T00:00:00.000' AS DateTime), CAST(N'2019-03-29T00:00:00.000' AS DateTime), 70230)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (87, CAST(N'2016-03-01T00:00:00.000' AS DateTime), CAST(N'2017-11-01T00:00:00.000' AS DateTime), 65467)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (88, CAST(N'2015-06-02T00:00:00.000' AS DateTime), CAST(N'2018-05-09T00:00:00.000' AS DateTime), 61630)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (89, CAST(N'2015-10-18T00:00:00.000' AS DateTime), CAST(N'2018-02-03T00:00:00.000' AS DateTime), 80809)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (90, CAST(N'2017-04-08T00:00:00.000' AS DateTime), NULL, 91980)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (91, CAST(N'2015-09-21T00:00:00.000' AS DateTime), CAST(N'2018-05-24T00:00:00.000' AS DateTime), 75975)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (92, CAST(N'2018-12-07T00:00:00.000' AS DateTime), NULL, 83824)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (93, CAST(N'2016-05-18T00:00:00.000' AS DateTime), NULL, 38041)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (94, CAST(N'2018-06-09T00:00:00.000' AS DateTime), NULL, 89381)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (95, CAST(N'2016-03-04T00:00:00.000' AS DateTime), CAST(N'2018-07-14T00:00:00.000' AS DateTime), 36575)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (96, CAST(N'2017-12-26T00:00:00.000' AS DateTime), NULL, 34769)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (97, CAST(N'2015-08-11T00:00:00.000' AS DateTime), NULL, 57100)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (98, CAST(N'2017-10-14T00:00:00.000' AS DateTime), NULL, 62449)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (99, CAST(N'2015-08-28T00:00:00.000' AS DateTime), CAST(N'2016-05-14T00:00:00.000' AS DateTime), 56645)
GO
INSERT [dbo].[lyft_drivers] ([index], [start_date], [end_date], [yearly_salary]) VALUES (100, CAST(N'2015-03-25T00:00:00.000' AS DateTime), CAST(N'2015-03-31T00:00:00.000' AS DateTime), 54050)
GO