IBS Software Interview Question

sql query having aggregate functions, regex functions