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


foo
bar
baz
moo
ins_date


foothing
bar_one
baz
strawberry_moosse
2019-03-17 06:37:00

foothing
bar_one
baz
strawberry_moosse
2020-01-14 01:34:00


SELECT
  s.foo,
  s.bar, 
  s.baz,
  s.moo,
  MAX(s.ins_date) mdate
FROM 
(
  SELECT *
  FROM dummy
  WHERE ins_date
  BETWEEN '2018-07-01 00:00:00'
  AND '2019-11-01 23:59:59'
) s

GROUP BY foo, bar, baz, moo
HAVING moo LIKE "%moo%"
AND baz = "baz"


foo
bar
baz
moo
mdate


foothing
bar_one
baz
amoosing
2018-11-29 05:31:00

foothing
bar_one
baz
mooman_being
2019-04-21 10:31:00

foothing
bar_one
baz
strawberry_moosse
2019-03-17 06:37:00


SELECT
  s1.foo,
  s1.bar, 
  s1.baz,
  s1.moo,
  MAX(s1.ins_date) mdate,
  s2.percentage,
  s2.yes,
  s2.maybe,
  s2.no
FROM 
(
  SELECT *
  FROM dummy
  WHERE ins_date
  BETWEEN '2018-07-01 00:00:00'
  AND '2019-11-01 23:59:59'
) s1
INNER JOIN
(
  SELECT id, percentage, yes, maybe, no
  FROM dummy
) s2
ON s2.id = s1.id

GROUP BY foo, bar, baz, moo
HAVING moo LIKE "%moo%"
AND baz = "baz"
Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 's2.percentage' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
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
foothing	bar_one	baz	strawberry_moosse	2019-03-17 06:37:00
foothing	bar_one	baz	strawberry_moosse	2020-01-14 01:34:00