In SQL Server, how do you utilize UPDATE from SELECT?

In SQL Server, how do you utilize UPDATE from SELECT?

More to explore

Based on this image's title: “In SQL Server, how do you utilize UPDATE from SELECT?