SQL For Business Intelligence | YoY, QoQ, MTD, YTD, QTD etc. in a Single SQL

[@sravyasrinivas]

Ankit, Really you are the god of SQL. Please keep helping people like us 🙏

[@Ashu23200]

agreed!!! god of sql

[@ankitbansal6]

Please do like the videos to increase its reach . Thank you in advance 🙏

[@umesh6600]

it's same fiscal year

[@chiranjib-konwar]

Ankit sir, please share the advanced SQL course link to buy. Hindi English both are fine

[@ankitbansal6]

@chiranjib-konwar www.namastesql.com/course-detail/think-sql-go-from-zero-to-hero-english

[@anandmahajan943]

@ankitbansal6 can u share whole query of time frame table please

[@ankitbansal6]

@@anandmahajan943 in the description box

[@dfkgjdflkg]

never thought it was possible, once I saw the title of your video I was convinced it is possible. Keep up the great work

[@subhajitdey6806]

Ankit , this is the top class things of Analystics , kindly share more videos like this where we get to know more real world problems; KPI metrices etc !

[@theraizadatalks14]

One word, tooooo good. How to handle all scenarios, you beautifully explained. Thanks

[@ankitbansal6]

Glad you liked it

[@Reva_Prime]

Bhaiya only adha samajh me aaya baaki isiliye nhi aaya qki mere concept clear nhi h . Soon I'll join your course. But I can say it's very advanced and important for a successful data analyst Thanks a lot

[@srinubathina7191]

wow superb never thought that it was possible Thank you Ankit Bro

[@HariKrishna-uy5bc]

Hi Ankit, Thank you very much for your content. You explain in simple layman terms and understandable way. I am facing a problem in finding the difference between two dates in hours excluding the weekend hours. Can you please make a video on this.This should cover all scenarios like first date and second date on weekdays and firstdate, seconddate on weekends, firstdate on weekday and 2nd date on weekend and firstdate on weekend and second date on weekday. I hope you understood the requirement. Giving one example for this requirement. date1 = 2024-02-24 21:00:00 and date2 = 2024-02-26 04:00:00 and the difference should give 4 hours as 2024-02-24 and 2024-02-25 are weekends and hours should be considered only for 2024-02-26 which is a weekday. Solution should cover all scenarios. Thanks!!

[@srinubathina4495]

Your sql videos are fantastic. Its really helped improve my skills keep up the great work sir thanknyou so much❤❤

[@addhyasumitra90]

this video is top notch !! awesome work

[@ankitbansal6]

Cheers 🥂

[@mohitsanskar1688]

sir, you are true champion.

[@rishabhjain133]

How awesome is that, thanks for the video.😀

[@ankitbansal6]

Thanks for watching!

[@sparshkapoor8517]

Simply Awesome!!

[@gayatri7536]

This is really good video 👍

[@ankitbansal6]

Glad you think so!

[@Gaurav-wy2wm]

Hi Ankit Please try to create videos on data modelling for any product

[@santoshkiran5858]

Awesome 😎

[@ankitbansal6]

Thank you! Cheers!

[@bankimdas9517]

Thank you sir for making this video

[@akashjha7277]

Superb❤

[@pateldh23]

Respected Ankit Sir, Best video for learning new things, Sir will you please share query I write query but i forgot what is the next step. And my concern is that i want to calculate for financial year which is starting from 1st April and ends on 31st march so please sir help me. First quarter is April to June then second then third and final last is january to march. Sir, I am poor in my english communication skills but trying my best for learning new things so please help me

[@ankitbansal6]

description box

[@Pirate_Hunter_Zoro11x]

My SQL GOD🙏

[@ankitbansal6]

🙏

[@shashank2004]

Awesome video sir...i have 9 yrs exp in Oracle database developer so to boost the profile which other tool or technology should be learn? Or sq/ plsql is enough?

[@ankitbansal6]

Learn python

[@ankitachougule4711]

Awesome video. I am new subscriber to your channel. Could you please share the link for datasets used in your video and also queries.

[@ankitbansal6]

In the description

[@Reva_Prime]

Thanks 😊🙏

[@PrasadBhandarkar-m4k]

Is calendar year table will refreshing automatically as per the time frame ? So we dont need hardcode anything

[@ankitbansal6]

Exactly

[@chiranjib-konwar]

I want to buy course in advanced SQL. Please share the link to buy the advanced sql course. Thanks 🙏

[@ankitbansal6]

www.namastesql.com/courses/SQL-For-Analytics-6301f405e4b0238f71788354

[@MITHUNKUMAR-nx8rd]

Where is create and insert statement for practice?

[@ankitbansal6]

description box

[@adharshsunny5154]

When to start AWS training

[@avneet_webdeveloperdepartm4182]

Hello sir please share the query so that we can practice

[@ankitbansal6]

in the description

[@g-ij9km]

where is the insert statement?

[@ankitbansal6]

check description

[@pateldh23]

Sir, please share query files please