Pregunta de entrevista de Google

count occurance joins and subquery