Update rows based on another table (correlated update)

Topic: sql, Advanced Query Scenarios. Level: Experienced.

The full answer to this question is available to Interview Reader members. See what is free and what Premium adds.