A Character large object (CLOB) is a SQL data type used to store a large amount of character data.
It's a specialized variant of large object (LOB) where data is stored in a file on the local file system with a text mime. The database would then decode the binary into a text and send it to you.
You would not use any clob column in any group by or window/aggregation function to perform any analtyics.
You would mostly retrieve the content and process it with a third application.