SQL Query | Compare monthly sales with previous month, same month previous year, first month of year

[@LearnatKnowstar]

Are you interested in attending an online SQL training course? We have received a few inquiries and are now planning one on 18 and 19 September 2021. This will be a 10 hours instructor led training covering SQL concepts as well as practical SQL query writing. The training cost is USD 100. If you are interested, please register here - forms.gle/y2U2eKmShq6JUnc29 Thank you 🙂

[@mihirforyou3531]

Mam what are the topics will be covered?

[@jashanpreetsingh4750]

Thanks a lot . Exactly solved the query i was having.

[@LearnatKnowstar]

Thank you 🙏

[@tlubaina]

You just saved my semester! Thanks

[@LearnatKnowstar]

Thank you

[@surajpatil3579]

Thanks mam, splendid explanation keep making content like this!!

[@saktibiswal6445]

Awesome explanation of LAG & OFFSET. Thanks!!

[@LearnatKnowstar]

Glad it was helpful!

[@chandudevarapu1578]

Thank you mam... Nice explained pls upload more videos like that... I will refer my friends also this type of scenarios very useful for us

[@LearnatKnowstar]

Thanks so much. Do make sure that you and your friends subscribe to the channel 🙂

[@mihirforyou3531]

Thank you Mam ... very useful.. nicely explained ☺️

[@LearnatKnowstar]

Thank you so much!

[@mummz3371]

I love watching your content because of the practical examples you use, thank you ❤️

[@LearnatKnowstar]

Thank you

[@MokshDrar]

@@LearnatKnowstar Thanks maam you are very smart

[@NareskanthM]

Great Explanation !

[@NareskanthM]

thanks sister ! very easy to understand !

[@LearnatKnowstar]

Glad it was helpful!

[@Regc10]

This is amazing helped me alot.

[@LearnatKnowstar]

Glad it was helpful.

[@nikolaybaranov2213]

Great explanation of how window functions work!

[@LearnatKnowstar]

Thank you

[@thatssodinesh7857]

You're great! Thank you so much

[@LearnatKnowstar]

Thank you!

[@brianducharme3418]

Thank you so very much!!

[@LearnatKnowstar]

Glad it helped!

[@pupu41784]

Thank you so much. I needed this! :D

[@LearnatKnowstar]

Glad it was helpful.

[@deepthimurali962]

Can you suggest how to use lag and offset if we want to compare Jan-Feb 2022 vs Jan-Feb 2023. I basically want to sum both jan and feb and compare the growth Thanks for this!

[@pravinm1490]

Nicely explained

[@LearnatKnowstar]

Thank you so much 🙂

[@mmohan692]

Akka super akka

[@pravinm1490]

very nicely explained

[@LearnatKnowstar]

Thank you so much 🙂

[@ajeshrajan8079]

Good explanation

[@LearnatKnowstar]

Thank you

[@Tech2BI]

As long as it's 2017 or higher versions we have functions for the same scenarios for previous versions like 2012 or 2008 r2 do you have any solution for this?

[@Hello.1253-e8v]

Excellent video series. Take a bow!! Could you please make something like this in Stored procs, performance tuning concepts

[@LearnatKnowstar]

Thanks so much. Sure, we will be posting videos on advanced topics in near future.

[@jadeldeek5100]

is possible to have monthly figures or yearly figures by columns not by row as your example? YEAR 1, YEAR 2 OR JAN, FEB , MARS ....

[@kesavanandt1195]

Good explanation madam...thank you very much. And mam, what modification is to be done in this query to get the next month sales.??

[@LearnatKnowstar]

Thank you. You can use the LEAD function instead of the LAG function

[@oladman9058]

Wow!

[@jonnybrooks97]

How can you drill down into specific columns with this, for example if you wanted to look at month on month changes for each store or region?

[@satyapalrawat7857]

Hi - this is very helpful. But what if there is a month missing in the last year data ?

[@arfathth5176]

Can i know the recommended on other customer sql query

[@ankurranjan3218]

Let suppose Data does not have consecutive months data. For example I am having 2020-01 and 2020-06 data only then If I am comparing with previous month using LAG then it will not be correct, right? As it will compare June from Jan but I wanted to compare only June from May. How to proceed for this type of scenrio.

[@pranavnair8977]

use cross join

[@vinaymaddi4801]

Can anyone explain the last scenario month(orderdate)-1 is taken for offset. How is that.

[@vinayv1940]

Hi , How about compare day wise sales with previous year day wise sales. ie; compare 29/9/2021 to 29/9/2022

[@pradeepvaka2545]

In the offset use year instead of month Lag(sum(sales) , year(orderdate))

[@rohitwaregaonkar3703]

Write a stored procedure that accepts the month and year as inputs Please help

[@balamuralibattala3283]

Hi everyone,How to find the company that has growth in three successive years.pls provide solution for it

[@gowthamev8745]

How to calculate interview in sql for example:- customer placed an order, we have to find the customer who placed an order more than 1 within 7 days

[@gelectiusdroid4147]

I can tell you

[@gmocore]

tnks !!! I

[@sivachaitanya6330]

month(date) inside lag() function is throwing error says month should not be here in mysql ................what is the solution.........lag(sum(amount),Month(date))-------------->ERRor?????????????????

[@advancewebdevelopment9802]

There are 897 days in query. How to get results by year months days in same query

[@ganeshkharad]

why use lag??? what if the data for a few months in a year are absent ???

[@RAJUBHAI-ww7em]

Yeah that's my issue too

[@smritichauhan6006]

such a ridiculous way of teaching