In this article you can see how to split strings
Or how to format the date into different output templates.
In this post: MySQL Count words in a column per
If you want to query min and max length of
In this post: Get N numbers per group Get N
It's a common operation in DB to have a need
If you want to find the highest or the lowest
In this post: SQL count null and not null values