MySQL 5.7

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

CREATE TABLE dummy(
   id         INTEGER  NOT NULL PRIMARY KEY 
  ,foo        VARCHAR(8) NOT NULL
  ,bar        VARCHAR(8) NOT NULL
  ,baz        VARCHAR(6) NOT NULL
  ,moo        VARCHAR(17) NOT NULL
  ,ins_date   VARCHAR(19) NOT NULL
  ,percentage INTEGER  NOT NULL
  ,yes        INTEGER  NOT NULL
  ,no         INTEGER  NOT NULL
  ,maybe      INTEGER  NOT NULL
);
INSERT INTO dummy 
   (id, foo, bar, baz, moo, ins_date, percentage, yes, no, maybe) VALUES
   (1,'foothing','bar_one','baz','moovie','2021-11-26 13:25:00',95,400,361,289)
,  (2,'foothing','bar_one','baz','moovie','2021-11-23 21:43:00',83,169,625,529)
,  (3,'foothing','bar_one','baz','moovie','2021-11-23 23:17:00',68,64,169,324)
,  (4,'foothing','bar_one','baz','amoosing','2021-11-12 16:13:00',64,19321,81,256)
,  (5,'foothing','bar_one','baz','amoosing','2021-11-12 15:54:00',90,18769,100,9)
,  (6,'foothing','bar_one','baz','amoosing','2020-04-07 18:08:00',90,22500,36,576)
,  (7,'foothing','bar_one','baz','amoosing','2020-04-20 23:47:00',62,28900,361,100)
,  (8,'foothing','bar_one','baz','amoosing','2020-01-14 04:49:00',60,30976,25,121)
,  (9,'foothing','bar_one','baz','strawberry_moosse','2019-03-17 06:37:00',80,23716,49,529)
,  (10,'foothing','bar_one','baz','strawberry_moosse','2020-01-14 01:34:00',55,23716,121,529)
,  (11,'foothing','bar_one','baz','mooman_being','2021-04-21 06:37:00',60,1444,484,100)
,  (12,'foothing','bar_one','baz','mooman_being','2019-04-21 10:31:00',70,3969,121,16)
,  (13,'foothing','bar_none','baz','mooman_being','2020-04-20 23:52:00',51,3025,64,289)
,  (14,'foothing','bar_one','baz','moot_point','2020-04-21 04:01:00',57,49,441,361)
,  (15,'foothing','bar_none','baz','remooval_truck','2020-04-21 02:54:00',95,400,576,36)
,  (16,'foothing','bar_one','baz','alastor_moody','2020-04-20 22:57:00',95,49,484,100)
,  (17,'foothing','bar_one','baz','moovie','2020-04-21 08:38:00',79,529,36,576)
,  (20,'foothing','bar_one','pizazz','amoosing','2018-06-27 10:37:00',94,676,16,400)
,  (23,'foothing','bar_one','pizazz','amoosing','2018-06-24 08:48:00',62,9,1,16)
,  (26,'foothing','bar_one','pizazz','amoosing','2019-04-01 22:35:00',99,23409,625,256)
,  (29,'foothing','bar_one','pizazz','amoosing','2019-04-09 10:34:00',76,33124,529,64)
,  (32,'foothing','bar_one','pizazz','amoosing','2019-04-12 08:36:00',63,28224,576,81)
,  (35,'foothing','bar_one','pizazz','amoosing','2019-04-18 06:51:00',92,19600,16,196)
,  (38,'foothing','bar_one','pizazz','amoosing','2018-05-26 06:59:00',81,25,529,196)
,  (41,'foothing','bar_one','pizazz','amoosing','2018-05-29 06:43:00',83,441,144,49)
,  (65,'foothing','bar_one','pizazz','amoosing','2018-07-01 08:34:00',92,121,64,225)
,  (68,'foothing','bar_one','pizazz','amoosing','2018-07-04 01:46:00',91,324,25,289)
,  (71,'foothing','bar_one','pizazz','amoosing','2018-07-06 23:44:00',65,196,676,100)
,  (74,'foothing','bar_one','pizazz','amoosing','2018-07-10 09:41:00',92,1024,121,81)
,  (77,'foothing','bar_one','pizazz','amoosing','2018-07-13 06:47:00',64,576,169,1)
,  (96,'foothing','bar_one','pizazz','amoosing','2018-08-02 10:34:00',78,1369,256,81)
,  (99,'foothing','bar_one','pizazz','amoosing','2018-08-04 08:25:00',82,2809,9,256)
,  (102,'foothing','bar_one','pizazz','amoosing','2018-08-07 06:49:00',87,576,9,676)
,  (105,'foothing','bar_one','pizazz','amoosing','2018-08-10 03:29:00',68,4225,1089,196)
,  (108,'foothing','bar_one','pizazz','amoosing','2018-08-13 03:59:00',92,1156,169,484)
,  (111,'foothing','bar_one','pizazz','amoosing','2018-08-16 05:34:00',63,1764,100,1089)
,  (114,'foothing','bar_one','pizazz','amoosing','2018-08-17 23:54:00',70,1369,81,900)
,  (117,'foothing','bar_one','pizazz','amoosing','2018-08-21 09:44:00',54,1849,64,25)
,  (120,'foothing','bar_one','pizazz','amoosing','2018-08-24 00:36:00',93,1225,576,36)
,  (123,'foothing','bar_one','pizazz','amoosing','2018-08-26 23:54:00',92,1444,900,1225)
,  (126,'foothing','bar_one','pizazz','amoosing','2018-08-30 08:32:00',67,400,144,4)
,  (129,'foothing','bar_one','pizazz','amoosing','2018-09-02 03:40:00',70,2916,1089,484)
,  (132,'foothing','bar_one','pizazz','amoosing','2018-09-05 03:57:00',95,4,1936,9)
,  (135,'foothing','bar_one','pizazz','amoosing','2018-09-07 23:55:00',92,2916,49,36)
,  (138,'foothing','bar_one','pizazz','amoosing','2018-09-11 10:33:00',76,2704,49,64)
,  (141,'foothing','bar_one','pizazz','amoosing','2018-09-14 04:39:00',85,4761,289,64)
,  (144,'foothing','bar_one','pizazz','amoosing','2018-09-17 08:36:00',67,2209,900,1681)
,  (147,'foothing','bar_one','pizazz','amoosing','2018-09-19 23:58:00',74,5329,256,196)
, (150,'foothing','bar_one','pizazz','amoosing','2018-09-23 00:28:00',57,1600,400,1089)
, (153,'foothing','bar_one','pizazz','amoosing','2018-09-26 01:34:00',100,144,9,289)
, (156,'foothing','bar_one','pizazz','amoosing','2018-09-28 03:34:00',92,169,256,289)
, (159,'foothing','bar_one','pizazz','amoosing','2018-10-01 07:29:00',92,1444,529,576)
, (162,'foothing','bar_one','pizazz','amoosing','2018-10-03 23:48:00',72,4225,225,361)
, (165,'foothing','bar_one','pizazz','amoosing','2018-10-07 07:58:00',82,2601,25,1764)
, (168,'foothing','bar_one','pizazz','amoosing','2018-10-10 04:37:00',78,2401,16,196)
, (171,'foothing','bar_one','pizazz','amoosing','2018-10-13 00:51:00',59,3249,256,3136)
, (174,'foothing','bar_one','pizazz','amoosing','2018-10-16 01:28:00',57,3136,484,625)
, (177,'foothing','bar_one','pizazz','amoosing','2018-10-18 09:59:00',57,2601,1,676)
, (180,'foothing','bar_one','pizazz','amoosing','2018-10-21 04:40:00',68,3721,25,169)
, (183,'foothing','bar_one','pizazz','amoosing','2018-10-24 06:37:00',74,3721,961,484)
, (186,'foothing','bar_one','pizazz','amoosing','2018-10-27 02:47:00',86,3600,676,2809)
, (189,'foothing','bar_one','pizazz','amoosing','2018-10-30 01:35:00',95,625,9,1849)
, (192,'foothing','bar_one','pizazz','amoosing','2018-11-02 07:41:00',60,3481,9,1681)
, (195,'foothing','bar_one','pizazz','amoosing','2018-11-05 01:48:00',63,6400,289,1764)
, (198,'foothing','bar_one','pizazz','amoosing','2018-11-08 06:28:00',57,6084,49,1089)
, (201,'foothing','bar_one','pizazz','amoosing','2018-11-11 06:47:00',53,2704,361,2116)
, (204,'foothing','bar_one','pizazz','amoosing','2018-11-14 07:37:00',64,13225,324,484)
, (207,'foothing','bar_one','baz','amoosing','2018-11-17 00:51:00',53,11236,144,36)
, (210,'foothing','bar_one','baz','amoosing','2018-11-20 01:38:00',99,8836,81,400)
, (213,'foothing','bar_one','baz','amoosing','2018-11-23 07:28:00',95,9801,841,0)
, (216,'foothing','bar_one','baz','amoosing','2018-11-26 01:57:00',70,8836,169,625)
, (219,'foothing','bar_one','baz','amoosing','2018-11-29 05:31:00',97,9025,1,361);
SELECT * FROM dummy ORDER BY ins_date ASC LIMIT 15 ;


id
foo
bar
baz
moo
ins_date
percentage
yes
no
maybe


38
foothing
bar_one
pizazz
amoosing
2018-05-26 06:59:00
81
25
529
196

41
foothing
bar_one
pizazz
amoosing
2018-05-29 06:43:00
83
441
144
49

23
foothing
bar_one
pizazz
amoosing
2018-06-24 08:48:00
62
9
1
16

20
foothing
bar_one
pizazz
amoosing
2018-06-27 10:37:00
94
676
16
400

65
foothing
bar_one
pizazz
amoosing
2018-07-01 08:34:00
92
121
64
225

68
foothing
bar_one
pizazz
amoosing
2018-07-04 01:46:00
91
324
25
289

71
foothing
bar_one
pizazz
amoosing
2018-07-06 23:44:00
65
196
676
100

74
foothing
bar_one
pizazz
amoosing
2018-07-10 09:41:00
92
1024
121
81

77
foothing
bar_one
pizazz
amoosing
2018-07-13 06:47:00
64
576
169
1

96
foothing
bar_one
pizazz
amoosing
2018-08-02 10:34:00
78
1369
256
81

99
foothing
bar_one
pizazz
amoosing
2018-08-04 08:25:00
82
2809
9
256

102
foothing
bar_one
pizazz
amoosing
2018-08-07 06:49:00
87
576
9
676

105
foothing
bar_one
pizazz
amoosing
2018-08-10 03:29:00
68
4225
1089
196

108
foothing
bar_one
pizazz
amoosing
2018-08-13 03:59:00
92
1156
169
484

111
foothing
bar_one
pizazz
amoosing
2018-08-16 05:34:00
63
1764
100
1089


SELECT foo, bar, baz, moo
, ins_date
, percentage
, yes, maybe, no
FROM dummy dum
WHERE EXISTS (
  SELECT 1
  FROM dummy dum2
  WHERE dum2.ins_date BETWEEN '2018-07-01 00:00:00'
                          AND '2019-11-01 23:59:59'
    AND dum2.moo LIKE '%moo%'
    AND dum2.baz = 'baz'
    AND dum2.foo = dum.foo
    AND dum2.bar = dum.bar
    AND dum2.baz = dum.baz
    AND dum2.moo = dum.moo
  GROUP BY foo, bar, baz, moo
  HAVING MAX(dum2.ins_date) = dum.ins_date
);


foo
bar
baz
moo
ins_date
percentage
yes
maybe
no


foothing
bar_one
baz
strawberry_moosse
2019-03-17 06:37:00
80
23716
529
49

foothing
bar_one
baz
mooman_being
2019-04-21 10:31:00
70
3969
16
121

foothing
bar_one
baz
amoosing
2018-11-29 05:31:00
97
9025
361
1

id	foo	bar	baz	moo	ins_date	percentage	yes	no	maybe
38	foothing	bar_one	pizazz	amoosing	2018-05-26 06:59:00	81	25	529	196
41	foothing	bar_one	pizazz	amoosing	2018-05-29 06:43:00	83	441	144	49
23	foothing	bar_one	pizazz	amoosing	2018-06-24 08:48:00	62	9	1	16
20	foothing	bar_one	pizazz	amoosing	2018-06-27 10:37:00	94	676	16	400
65	foothing	bar_one	pizazz	amoosing	2018-07-01 08:34:00	92	121	64	225
68	foothing	bar_one	pizazz	amoosing	2018-07-04 01:46:00	91	324	25	289
71	foothing	bar_one	pizazz	amoosing	2018-07-06 23:44:00	65	196	676	100
74	foothing	bar_one	pizazz	amoosing	2018-07-10 09:41:00	92	1024	121	81
77	foothing	bar_one	pizazz	amoosing	2018-07-13 06:47:00	64	576	169	1
96	foothing	bar_one	pizazz	amoosing	2018-08-02 10:34:00	78	1369	256	81
99	foothing	bar_one	pizazz	amoosing	2018-08-04 08:25:00	82	2809	9	256
102	foothing	bar_one	pizazz	amoosing	2018-08-07 06:49:00	87	576	9	676
105	foothing	bar_one	pizazz	amoosing	2018-08-10 03:29:00	68	4225	1089	196
108	foothing	bar_one	pizazz	amoosing	2018-08-13 03:59:00	92	1156	169	484
111	foothing	bar_one	pizazz	amoosing	2018-08-16 05:34:00	63	1764	100	1089

foo	bar	baz	moo	ins_date	percentage	yes	maybe	no
foothing	bar_one	baz	strawberry_moosse	2019-03-17 06:37:00	80	23716	529	49
foothing	bar_one	baz	mooman_being	2019-04-21 10:31:00	70	3969	16	121
foothing	bar_one	baz	amoosing	2018-11-29 05:31:00	97	9025	361	1