TikTok Interview Question

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