TSQL Execution Plan

Hash Match

use each row from the top input to build a hash table, and each row from the bottom input to probe into the hash table, outputting all matching rows.

Clustered Index Scan

Scanning a clustered index, entirely or only a range.

Compute scalar

Compute new values from existing values in a row

Stream aggregate

Compute summary values for groups of rows in a suitably sorted stream.

Sort

Sort the input