How would you use SQL window functions to analyze trends over time in an enterprise dataset at BMC Software?
