Pregunta de entrevista de Comscore

How to do SQL multiplications after using group-by functions? How to find find substring in a string using python?