On: Medium-hard SQL interview questions

[beckingz]

For cumulative averages why not use window functions?

[thomzi12 → beckingz]

Good catch -- I can add that in as an alternate solution. Thanks!

[beckingz → thomzi12]

Of course!

Now the thing to do is for me to recreate your list on github.

[thomzi12 → beckingz]

Yes -- making this a proper webpage with an embedded SQL editor like selectstarsql.com does would be a good next step

[beckingz → thomzi12]

Are there any good ways to embed SQL in markdown? Like JupyterLab notebooks?

[cbcoutinho → beckingz]

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/noteb...

[beckingz → cbcoutinho]

Thanks! I'll have to check that out.