4 ms·

For cumulative averages why not use window functions?

• thomzi12 7y ago
  Good catch -- I can add that in as an alternate solution. Thanks!
  • beckingz 7y ago
    Of course! Now the thing to do is for me to recreate your list on github.
    • thomzi12 7y ago
      Yes -- making this a proper webpage with an embedded SQL editor like selectstarsql.com does would be a good next step
      • beckingz 7y ago
        Are there any good ways to embed SQL in markdown? Like JupyterLab notebooks?
        • cbcoutinho 7y ago
          Yes, Azure Data Studio allows you to embed SQL in notebooks right out of the box: https://docs.microsoft.com/en-us/sql/azure-data-studio/notebooks-guidance?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/azure-data-studio/noteb...
          • beckingz 7y ago
            Thanks! I'll have to check that out.
• deleted 7y ago
  [deleted]