Pergunta de entrevista da empresa TikTok

given three tables, write SQL to do the required query that may involve order by, group by, and some logical check. This question is not hard.