IBS Software interview question

sql query having aggregate functions, regex functions