Window functions are a powerful SQL feature that let you compare results against other results within a query. With them, you can you can compare one row to other rows in a query to calculate each row as a percent of the total, for example, or to add a moving average to a report.
Danielle is a Data Scientist at Treehouse, with a background in a variety of areas of analysis including finance, marketing, logistics, and web. She is based in Las Vegas, Nevada.
You need to sign up for Treehouse in order to download course videos.