Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on Instagram Handles :- @createwithchirag - instagram.com/createwithchirag/ @learn.with.chirag - instagram.com/learn.with.chirag/ LinkedIn: www.linkedin.com/in/chirag-sehgal-9200111b8/ Let's stay connected and keep the creativity flowing! 💡
@@ashutoshrastogi5381 Due to my exams this month, I've been uploading videos less frequently. However, starting from November 26th, I plan to upload videos daily. So Stay Tuned😄
As per sql queru execution order group by is executed before select so how is the aliased name month working with group by before the execution of select statement
Reason behind COUNT (state = 'approved') not working is because, state = 'approved' returns either 1 (true) or 0 (false), COUNT functions counts all types of NON-NULL values, meaning that both 0 and 1 will be counted in this case. Reason behing SUM working, is that it calculates the sum of the output (state = 'approved') provides. Hence 0 + 1 will give 1, whereas COUNT(0, 1) will give 2
sir ek question ko kitne der tak time dena hota h before watching soln? kya sbse ek hi baar me solve ho jate h ya mujh jese logo ko sln dekan padta h jadatar? or kyi baar soln dekne k baad solve ho jata h fir vapis solve kre kafi time baad to nhi hota?
yeh sabke saath hota hai ! first read the question and try to understand it ! ....If you are not able to understand the question then watch my question explanation ! after that try to solve query yourself first ! break the query in steps and try to solve it ! ......if not able to do then watch my solution and query explanation !....... also if you were finding it very hard to solve then bookmark the question and after completing the playlist go and try again that question ! don't give more than 10-15 min on thinking a query ! ...you won't be getting that much time for SQL in interviews and online assessments.
Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on
Instagram Handles :-
@createwithchirag - instagram.com/createwithchirag/
@learn.with.chirag - instagram.com/learn.with.chirag/
LinkedIn: www.linkedin.com/in/chirag-sehgal-9200111b8/
Let's stay connected and keep the creativity flowing! 💡
Your videos are very informative, and good to learn and practice about the concepts of SQL....👍
Glad to hear that! Keep supporting ❤️
@@learnwithchirag 😇will the playlist get updated day to day? As the last update was 3 days earlier....☺
@@ashutoshrastogi5381 Due to my exams this month, I've been uploading videos less frequently. However, starting from November 26th, I plan to upload videos daily. So Stay Tuned😄
Nice explanation sir!!!!!
Thanks for liking :-)
As per sql queru execution order group by is executed before select so how is the aliased name month working with group by before the execution of select statement
Thank you bhaiya. 🙏🏻
Bhaiya, I tried writing COUNT( state = 'approved' ) as approved_count. But this doesn't work, only SUM works. Why is it so?
I too have same doubt . Have you figured it out?
Reason behind COUNT (state = 'approved') not working is because, state = 'approved' returns either 1 (true) or 0 (false), COUNT functions counts all types of NON-NULL values, meaning that both 0 and 1 will be counted in this case.
Reason behing SUM working, is that it calculates the sum of the output (state = 'approved') provides. Hence 0 + 1 will give 1, whereas COUNT(0, 1) will give 2
check your all commas that's it
why did we use sum(state = 'approved') as approved_count
not count function
when I used count it gave me error, please make me understand this.
just check your all commas is there or not if missing it won't work
sir ek question ko kitne der tak time dena hota h before watching soln?
kya sbse ek hi baar me solve ho jate h ya mujh jese logo ko sln dekan padta h jadatar?
or kyi baar soln dekne k baad solve ho jata h fir vapis solve kre kafi time baad to nhi hota?
yeh sabke saath hota hai !
first read the question and try to understand it ! ....If you are not able to understand the question then watch my question explanation !
after that try to solve query yourself first ! break the query in steps and try to solve it ! ......if not able to do then watch my solution and query explanation !.......
also if you were finding it very hard to solve then bookmark the question and after completing the playlist go and try again that question !
don't give more than 10-15 min on thinking a query ! ...you won't be getting that much time for SQL in interviews and online assessments.
wow! thankss
You're welcome! Keep supporting ❤️
not clear transction count