Window Functions enable groupwise aggregations and ranking inside groups in an example set. 

Expression-based Join combines two example sets based on a formula, not just on equality like the Join operator.