Pregunta de entrevista de Citizen (NY)

SQL question which required CTE

Respuesta de la entrevista

Anónimo

23 de jun de 2022

I struggled with the question because I wasn't as familiar with CTE's. Interviewer didn't really try to guide me, she just tried to solve the question herself and she didn't get the correct answer herself.