Pergunta de entrevista da empresa Wix

Python and sql. Need to know with and subquery