MariaDB [quarry]> select date_format(timestamp, '%Y-%m-%d'), count(*) from query_run where timestamp >= '2021-01-01' group by YEAR(timestamp), month(timestamp), dayofmonth(timestamp) order by timestamp desc; +------------------------------------+----------+ | date_format(timestamp, '%Y-%m-%d') | count(*) | +------------------------------------+----------+ | 2021-08-26 | 224 | | 2021-08-25 | 121 | | 2021-08-24 | 235 | | 2021-08-23 | 248 | | 2021-08-22 | 196 | | 2021-08-21 | 136 | | 2021-08-20 | 212 | | 2021-08-19 | 223 | | 2021-08-18 | 210 | | 2021-08-17 | 260 | | 2021-08-16 | 281 | | 2021-08-15 | 196 | | 2021-08-14 | 181 | | 2021-08-13 | 180 | | 2021-08-12 | 362 | | 2021-08-11 | 214 | | 2021-08-10 | 135 | | 2021-08-09 | 226 | | 2021-08-08 | 163 | | 2021-08-07 | 156 | | 2021-08-06 | 126 | | 2021-08-05 | 274 | | 2021-08-04 | 301 | | 2021-08-03 | 290 | | 2021-08-02 | 153 | | 2021-08-01 | 283 | | 2021-07-31 | 162 | | 2021-07-30 | 220 | | 2021-07-29 | 356 | | 2021-07-28 | 205 | | 2021-07-27 | 355 | | 2021-07-26 | 304 | | 2021-07-25 | 266 | | 2021-07-24 | 224 | | 2021-07-23 | 285 | | 2021-07-22 | 167 | | 2021-07-21 | 188 | | 2021-07-20 | 219 | | 2021-07-19 | 290 | | 2021-07-18 | 240 | | 2021-07-17 | 225 | | 2021-07-16 | 269 | | 2021-07-15 | 222 | | 2021-07-14 | 155 | | 2021-07-13 | 286 | | 2021-07-12 | 214 | | 2021-07-11 | 285 | | 2021-07-10 | 469 | | 2021-07-09 | 173 | | 2021-07-08 | 394 | | 2021-07-07 | 335 | | 2021-07-06 | 278 | | 2021-07-05 | 381 | | 2021-07-04 | 263 | | 2021-07-03 | 210 | | 2021-07-02 | 113 | | 2021-07-01 | 144 | | 2021-06-30 | 252 | | 2021-06-29 | 246 | | 2021-06-28 | 175 | | 2021-06-27 | 233 | | 2021-06-26 | 206 | | 2021-06-25 | 205 | | 2021-06-24 | 291 | | 2021-06-23 | 244 | | 2021-06-22 | 216 | | 2021-06-21 | 153 | | 2021-06-20 | 208 | | 2021-06-19 | 302 | | 2021-06-18 | 220 | | 2021-06-17 | 203 | | 2021-06-16 | 243 | | 2021-06-15 | 361 | | 2021-06-14 | 227 | | 2021-06-13 | 146 | | 2021-06-12 | 315 | | 2021-06-11 | 329 | | 2021-06-10 | 256 | | 2021-06-09 | 252 | | 2021-06-08 | 276 | | 2021-06-07 | 285 | | 2021-06-06 | 336 | | 2021-06-05 | 354 | | 2021-06-04 | 285 | | 2021-06-03 | 417 | | 2021-06-02 | 273 | | 2021-06-01 | 435 | | 2021-05-31 | 260 | | 2021-05-30 | 215 | | 2021-05-29 | 214 | | 2021-05-28 | 202 | | 2021-05-27 | 181 | | 2021-05-26 | 202 | | 2021-05-25 | 174 | | 2021-05-24 | 227 | | 2021-05-23 | 198 | | 2021-05-22 | 175 | | 2021-05-21 | 160 | | 2021-05-20 | 164 | | 2021-05-19 | 259 | | 2021-05-18 | 227 | | 2021-05-17 | 221 | | 2021-05-16 | 198 | | 2021-05-15 | 221 | | 2021-05-14 | 183 | | 2021-05-13 | 243 | | 2021-05-12 | 306 | | 2021-05-11 | 237 | | 2021-05-10 | 351 | | 2021-05-09 | 321 | | 2021-05-08 | 363 | | 2021-05-07 | 365 | | 2021-05-06 | 330 | | 2021-05-05 | 296 | | 2021-05-04 | 650 | | 2021-05-03 | 201 | | 2021-05-02 | 200 | | 2021-05-01 | 205 | | 2021-04-30 | 361 | | 2021-04-29 | 328 | | 2021-04-28 | 399 | | 2021-04-27 | 216 | | 2021-04-26 | 216 | | 2021-04-25 | 253 | | 2021-04-24 | 111 | | 2021-04-23 | 137 | | 2021-04-22 | 138 | | 2021-04-21 | 189 | | 2021-04-20 | 171 | | 2021-04-19 | 244 | | 2021-04-18 | 185 | | 2021-04-17 | 128 | | 2021-04-16 | 228 | | 2021-04-15 | 185 | | 2021-04-14 | 161 | | 2021-04-13 | 105 | | 2021-04-12 | 240 | | 2021-04-11 | 188 | | 2021-04-10 | 212 | | 2021-04-09 | 162 | | 2021-04-08 | 230 | | 2021-04-07 | 304 | | 2021-04-06 | 252 | | 2021-04-05 | 188 | | 2021-04-04 | 259 | | 2021-04-03 | 286 | | 2021-04-02 | 275 | | 2021-04-01 | 340 | | 2021-03-31 | 262 | | 2021-03-30 | 290 | | 2021-03-29 | 184 | | 2021-03-28 | 178 | | 2021-03-27 | 157 | | 2021-03-26 | 151 | | 2021-03-25 | 359 | | 2021-03-24 | 320 | | 2021-03-23 | 221 | | 2021-03-22 | 427 | | 2021-03-21 | 123 | | 2021-03-20 | 416 | | 2021-03-19 | 227 | | 2021-03-18 | 105 | | 2021-03-17 | 181 | | 2021-03-16 | 204 | | 2021-03-15 | 397 | | 2021-03-14 | 297 | | 2021-03-13 | 180 | | 2021-03-12 | 253 | | 2021-03-11 | 200 | | 2021-03-10 | 243 | | 2021-03-09 | 262 | | 2021-03-08 | 400 | | 2021-03-07 | 482 | | 2021-03-06 | 337 | | 2021-03-05 | 180 | | 2021-03-04 | 111 | | 2021-03-03 | 170 | | 2021-03-02 | 153 | | 2021-03-01 | 168 | | 2021-02-28 | 245 | | 2021-02-27 | 289 | | 2021-02-26 | 467 | | 2021-02-25 | 312 | | 2021-02-24 | 193 | | 2021-02-23 | 401 | | 2021-02-22 | 464 | | 2021-02-21 | 566 | | 2021-02-20 | 339 | | 2021-02-19 | 297 | | 2021-02-18 | 475 | | 2021-02-17 | 244 | | 2021-02-16 | 156 | | 2021-02-15 | 93 | | 2021-02-14 | 293 | | 2021-02-13 | 208 | | 2021-02-12 | 217 | | 2021-02-11 | 187 | | 2021-02-10 | 277 | | 2021-02-09 | 120 | | 2021-02-08 | 211 | | 2021-02-07 | 130 | | 2021-02-06 | 118 | | 2021-02-05 | 162 | | 2021-02-04 | 91 | | 2021-02-03 | 217 | | 2021-02-02 | 420 | | 2021-02-01 | 234 | | 2021-01-31 | 140 | | 2021-01-30 | 193 | | 2021-01-29 | 253 | | 2021-01-28 | 203 | | 2021-01-27 | 264 | | 2021-01-26 | 235 | | 2021-01-25 | 299 | | 2021-01-24 | 425 | | 2021-01-23 | 453 | | 2021-01-22 | 455 | | 2021-01-21 | 226 | | 2021-01-20 | 193 | | 2021-01-19 | 414 | | 2021-01-18 | 372 | | 2021-01-17 | 270 | | 2021-01-16 | 467 | | 2021-01-15 | 385 | | 2021-01-14 | 420 | | 2021-01-13 | 221 | | 2021-01-12 | 250 | | 2021-01-11 | 146 | | 2021-01-10 | 155 | | 2021-01-09 | 183 | | 2021-01-08 | 218 | | 2021-01-07 | 188 | | 2021-01-06 | 244 | | 2021-01-05 | 198 | | 2021-01-04 | 166 | | 2021-01-03 | 319 | | 2021-01-02 | 255 | | 2021-01-01 | 253 | +------------------------------------+----------+ 238 rows in set (0.40 sec)