## Metadata - Author: [[data-council|Data Council]] - Full Title:: Cubing and Metrics in SQL, Oh My! - Category:: #🗞️Articles - Document Tags:: [[sql|Sql]], - URL:: https://youtube.com/watch?v=oo1uwJ3qHwE&feature=share - Finished date:: [[2023-06-02]] ## Highlights > onegood reason to use windowed aggregatefunctions isthat if if you specify your query as awindowed aggregate rather than aself-join the database can oftenevaluate this as a one pass ([View Highlight](https://read.readwise.io/read/01h1w14zhm0x9x2g3yqbchbb3b))