Supercharge Your SQL Skills with Lead & Lag Functions

[@uc7602]

Great video! Enjoyed watching you use of Excel formulas to help code and validate the LAG(), LEAD() and AVG() functions using SQL. Thanks Anthony!

[@AnthonySmoak]

Thank you! I'm glad you like the Excel piece I put in the video to explain the concept.

[@ifortniteclipz9946]

Hello, I’m wondering if you have or can do a tutorial on creating a parameter table such as start datetime & end datetime and how to incorporate this so a user can input the date and use it to refresh the table being pulled from a database?

[@AnthonySmoak]

Somewhat similar: kzbin.info/www/bejne/banWfZKdfctsjdUfeature=shared