MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable (
trip_id	BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
start_date DATETIME,
end_date DATETIME);

INSERT INTO mytable (start_date, end_date)
WITH RECURSIVE cte AS (
SELECT NOW()-INTERVAL 2 YEAR dt UNION ALL
SELECT dt+INTERVAL 11 DAY FROM cte WHERE dt+INTERVAL 1 MONTH <= NOW())
SELECT dt, dt+INTERVAL 10 MINUTE FROM cte;
/*removing some data assuming "no trips was made on this year-month"*/
DELETE FROM mytable WHERE YEAR(start_date) IN ('2020','2021') 
 AND MONTH(start_date) IN ('02','05','07','11')
SELECT * FROM mytable;


trip_id
start_date
end_date


1
2019-12-30 02:08:00
2019-12-30 02:18:00

2
2020-01-10 02:08:00
2020-01-10 02:18:00

3
2020-01-21 02:08:00
2020-01-21 02:18:00

7
2020-03-05 02:08:00
2020-03-05 02:18:00

8
2020-03-16 02:08:00
2020-03-16 02:18:00

9
2020-03-27 02:08:00
2020-03-27 02:18:00

10
2020-04-07 02:08:00
2020-04-07 02:18:00

11
2020-04-18 02:08:00
2020-04-18 02:18:00

12
2020-04-29 02:08:00
2020-04-29 02:18:00

15
2020-06-01 02:08:00
2020-06-01 02:18:00

16
2020-06-12 02:08:00
2020-06-12 02:18:00

17
2020-06-23 02:08:00
2020-06-23 02:18:00

21
2020-08-06 02:08:00
2020-08-06 02:18:00

22
2020-08-17 02:08:00
2020-08-17 02:18:00

23
2020-08-28 02:08:00
2020-08-28 02:18:00

24
2020-09-08 02:08:00
2020-09-08 02:18:00

25
2020-09-19 02:08:00
2020-09-19 02:18:00

26
2020-09-30 02:08:00
2020-09-30 02:18:00

27
2020-10-11 02:08:00
2020-10-11 02:18:00

28
2020-10-22 02:08:00
2020-10-22 02:18:00

32
2020-12-05 02:08:00
2020-12-05 02:18:00

33
2020-12-16 02:08:00
2020-12-16 02:18:00

34
2020-12-27 02:08:00
2020-12-27 02:18:00

35
2021-01-07 02:08:00
2021-01-07 02:18:00

36
2021-01-18 02:08:00
2021-01-18 02:18:00

37
2021-01-29 02:08:00
2021-01-29 02:18:00

40
2021-03-03 02:08:00
2021-03-03 02:18:00

41
2021-03-14 02:08:00
2021-03-14 02:18:00

42
2021-03-25 02:08:00
2021-03-25 02:18:00

43
2021-04-05 02:08:00
2021-04-05 02:18:00

44
2021-04-16 02:08:00
2021-04-16 02:18:00

45
2021-04-27 02:08:00
2021-04-27 02:18:00

49
2021-06-10 02:08:00
2021-06-10 02:18:00

50
2021-06-21 02:08:00
2021-06-21 02:18:00

54
2021-08-04 02:08:00
2021-08-04 02:18:00

55
2021-08-15 02:08:00
2021-08-15 02:18:00

56
2021-08-26 02:08:00
2021-08-26 02:18:00

57
2021-09-06 02:08:00
2021-09-06 02:18:00

58
2021-09-17 02:08:00
2021-09-17 02:18:00

59
2021-09-28 02:08:00
2021-09-28 02:18:00

60
2021-10-09 02:08:00
2021-10-09 02:18:00

61
2021-10-20 02:08:00
2021-10-20 02:18:00

62
2021-10-31 02:08:00
2021-10-31 02:18:00

65
2021-12-03 02:08:00
2021-12-03 02:18:00


/*This is your current query*/
    SELECT
    year,
    month,
    trips_this_month,
    trips_previous_month,
    case when difference_from_previous_month < 0 then false else true end as is_increased
FROM    
(SELECT    
    year,
    month,
    number_of_trips AS trips_this_month,
    LAG(number_of_trips,1,0) over (order by year,month) AS trips_previous_month,    
    number_of_trips - LAG(number_of_trips,1,0) OVER(order by year,month) AS difference_from_previous_month    
    FROM(
        SELECT EXTRACT(Month FROM start_date) AS month,
               EXTRACT(Year FROM start_date) AS year,
               COUNT(*) as number_of_trips
               FROM mytable
    group by  month ,year
    ) a
    order by year, month
    limit 100
) b


year
month
trips_this_month
trips_previous_month
is_increased


2019
12
1
0
1

2020
1
2
1
1

2020
3
3
2
1

2020
4
3
3
1

2020
6
3
3
1

2020
8
3
3
1

2020
9
3
3
1

2020
10
2
3
0

2020
12
3
2
1

2021
1
3
3
1

2021
3
3
3
1

2021
4
3
3
1

2021
6
2
3
0

2021
8
3
2
1

2021
9
3
3
1

2021
10
3
3
1

2021
12
1
3
0


WITH RECURSIVE cte AS (
SELECT MIN(start_date) minstdt, MAX(start_date) maxstdt FROM mytable
UNION ALL
SELECT minstdt+INTERVAL 1 MONTH, maxstdt FROM cte WHERE minstdt+INTERVAL 1 MONTH <= maxstdt )
SELECT
     YEAR(cte.minstdt) AS year,
     MONTH(cte.minstdt) AS month,
     start_date
    FROM cte 
LEFT JOIN mytable 
 ON YEAR(cte.minstdt)=YEAR(start_date) 
  AND MONTH(cte.minstdt)=MONTH(start_date) 
ORDER BY year, month;


year
month
start_date


2019
12
2019-12-30 02:08:00

2020
1
2020-01-21 02:08:00

2020
1
2020-01-10 02:08:00

2020
2
null

2020
3
2020-03-27 02:08:00

2020
3
2020-03-16 02:08:00

2020
3
2020-03-05 02:08:00

2020
4
2020-04-29 02:08:00

2020
4
2020-04-18 02:08:00

2020
4
2020-04-07 02:08:00

2020
5
null

2020
6
2020-06-23 02:08:00

2020
6
2020-06-12 02:08:00

2020
6
2020-06-01 02:08:00

2020
7
null

2020
8
2020-08-28 02:08:00

2020
8
2020-08-17 02:08:00

2020
8
2020-08-06 02:08:00

2020
9
2020-09-30 02:08:00

2020
9
2020-09-19 02:08:00

2020
9
2020-09-08 02:08:00

2020
10
2020-10-22 02:08:00

2020
10
2020-10-11 02:08:00

2020
11
null

2020
12
2020-12-05 02:08:00

2020
12
2020-12-16 02:08:00

2020
12
2020-12-27 02:08:00

2021
1
2021-01-29 02:08:00

2021
1
2021-01-18 02:08:00

2021
1
2021-01-07 02:08:00

2021
2
null

2021
3
2021-03-25 02:08:00

2021
3
2021-03-14 02:08:00

2021
3
2021-03-03 02:08:00

2021
4
2021-04-27 02:08:00

2021
4
2021-04-16 02:08:00

2021
4
2021-04-05 02:08:00

2021
5
null

2021
6
2021-06-21 02:08:00

2021
6
2021-06-10 02:08:00

2021
7
null

2021
8
2021-08-26 02:08:00

2021
8
2021-08-15 02:08:00

2021
8
2021-08-04 02:08:00

2021
9
2021-09-28 02:08:00

2021
9
2021-09-17 02:08:00

2021
9
2021-09-06 02:08:00

2021
10
2021-10-31 02:08:00

2021
10
2021-10-20 02:08:00

2021
10
2021-10-09 02:08:00

2021
11
null


WITH RECURSIVE cte AS (
SELECT MIN(start_date) minstdt, MAX(start_date) maxstdt FROM mytable
UNION ALL
SELECT minstdt+INTERVAL 1 MONTH, maxstdt FROM cte 
       WHERE minstdt+INTERVAL 1 MONTH <= maxstdt )
       
SELECT year,
       month,
       number_of_trips,
       number_of_trips-IFNULL(prev_month_number_of_trips,0) AS This_month_vs_prev_month,
       IF(number_of_trips > prev_month_number_of_trips,1,0) AS Is_increased
FROM
(SELECT
     YEAR(cte.minstdt) AS year,
     MONTH(cte.minstdt) AS month,
     SUM(CASE WHEN start_date IS NULL THEN 0 ELSE 1 END) AS number_of_trips,
     LAG(SUM(CASE WHEN start_date IS NULL THEN 0 ELSE 1 END)) 
         OVER (ORDER BY YEAR(cte.minstdt), MONTH(cte.minstdt)) AS prev_month_number_of_trips
    FROM cte 
LEFT JOIN mytable 
 ON YEAR(cte.minstdt)=YEAR(start_date) 
  AND MONTH(cte.minstdt)=MONTH(start_date) 
GROUP BY year, month) V
ORDER BY year, month;


year
month
number_of_trips
This_month_vs_prev_month
Is_increased


2019
12
1
1
0

2020
1
2
1
1

2020
2
0
-2
0

2020
3
3
3
1

2020
4
3
0
0

2020
5
0
-3
0

2020
6
3
3
1

2020
7
0
-3
0

2020
8
3
3
1

2020
9
3
0
0

2020
10
2
-1
0

2020
11
0
-2
0

2020
12
3
3
1

2021
1
3
0
0

2021
2
0
-3
0

2021
3
3
3
1

2021
4
3
0
0

2021
5
0
-3
0

2021
6
2
2
1

2021
7
0
-2
0

2021
8
3
3
1

2021
9
3
0
0

2021
10
3
0
0

2021
11
0
-3
0

trip_id	start_date	end_date
1	2019-12-30 02:08:00	2019-12-30 02:18:00
2	2020-01-10 02:08:00	2020-01-10 02:18:00
3	2020-01-21 02:08:00	2020-01-21 02:18:00
7	2020-03-05 02:08:00	2020-03-05 02:18:00
8	2020-03-16 02:08:00	2020-03-16 02:18:00
9	2020-03-27 02:08:00	2020-03-27 02:18:00
10	2020-04-07 02:08:00	2020-04-07 02:18:00
11	2020-04-18 02:08:00	2020-04-18 02:18:00
12	2020-04-29 02:08:00	2020-04-29 02:18:00
15	2020-06-01 02:08:00	2020-06-01 02:18:00
16	2020-06-12 02:08:00	2020-06-12 02:18:00
17	2020-06-23 02:08:00	2020-06-23 02:18:00
21	2020-08-06 02:08:00	2020-08-06 02:18:00
22	2020-08-17 02:08:00	2020-08-17 02:18:00
23	2020-08-28 02:08:00	2020-08-28 02:18:00
24	2020-09-08 02:08:00	2020-09-08 02:18:00
25	2020-09-19 02:08:00	2020-09-19 02:18:00
26	2020-09-30 02:08:00	2020-09-30 02:18:00
27	2020-10-11 02:08:00	2020-10-11 02:18:00
28	2020-10-22 02:08:00	2020-10-22 02:18:00
32	2020-12-05 02:08:00	2020-12-05 02:18:00
33	2020-12-16 02:08:00	2020-12-16 02:18:00
34	2020-12-27 02:08:00	2020-12-27 02:18:00
35	2021-01-07 02:08:00	2021-01-07 02:18:00
36	2021-01-18 02:08:00	2021-01-18 02:18:00
37	2021-01-29 02:08:00	2021-01-29 02:18:00
40	2021-03-03 02:08:00	2021-03-03 02:18:00
41	2021-03-14 02:08:00	2021-03-14 02:18:00
42	2021-03-25 02:08:00	2021-03-25 02:18:00
43	2021-04-05 02:08:00	2021-04-05 02:18:00
44	2021-04-16 02:08:00	2021-04-16 02:18:00
45	2021-04-27 02:08:00	2021-04-27 02:18:00
49	2021-06-10 02:08:00	2021-06-10 02:18:00
50	2021-06-21 02:08:00	2021-06-21 02:18:00
54	2021-08-04 02:08:00	2021-08-04 02:18:00
55	2021-08-15 02:08:00	2021-08-15 02:18:00
56	2021-08-26 02:08:00	2021-08-26 02:18:00
57	2021-09-06 02:08:00	2021-09-06 02:18:00
58	2021-09-17 02:08:00	2021-09-17 02:18:00
59	2021-09-28 02:08:00	2021-09-28 02:18:00
60	2021-10-09 02:08:00	2021-10-09 02:18:00
61	2021-10-20 02:08:00	2021-10-20 02:18:00
62	2021-10-31 02:08:00	2021-10-31 02:18:00
65	2021-12-03 02:08:00	2021-12-03 02:18:00

year	month	trips_this_month	trips_previous_month	is_increased
2019	12	1	0	1
2020	1	2	1	1
2020	3	3	2	1
2020	4	3	3	1
2020	6	3	3	1
2020	8	3	3	1
2020	9	3	3	1
2020	10	2	3	0
2020	12	3	2	1
2021	1	3	3	1
2021	3	3	3	1
2021	4	3	3	1
2021	6	2	3	0
2021	8	3	2	1
2021	9	3	3	1
2021	10	3	3	1
2021	12	1	3	0