SQL每日一题(20220106)
select cast(concat(
substr(date_add(date_sub(Times, INTERVAL minute(Times) minute), INTERVAL floor(minute(Times) / 15) * 15 minute),
1, 17), '00') as datetime),
count(1)
from t0524
group by cast(concat(
substr(date_add(date_sub(Times, INTERVAL minute(Times) minute), INTERVAL floor(minute(Times) / 15) * 15 minute),
1, 17), '00') as datetime);