Pergunta de entrevista da empresa TikTok

SQL script that takes the maximum of a value in one table, based on a join of data from another table