Task: UPDATE with JOIN in SQLite

Task: UPDATE with JOIN in SQLite: a task in Terminal-Lego-15k (Harbor dataset). SQLite does not support the UPDATE ... JOIN syntax that MySQL allows. Your task is to write a SQLite-compatible SQL script that achieves the equivalent of an UPDATE with a JOIN between two tables.