Monthly Transactions I | Leetcode 1193 | Crack SQL Interviews in 50 Qs #mysql #leetcode

Want to crack SQL interviews? Check out our latest video!!!

A 50-questions SQL study plan to ace any interview.
This tutorial will walk you through the solution in easy steps. This is an easy-level question from Leetcode.

Consistency is what transforms average into excellence.
So be consistent & keep Coding💻!!

Timecodes
0:00 - Introduction
0:17 - Question Explanation
1:00 - Understanding Concept with the help of Example
4:41 - Writing SQL Query
7:34 - Explanation of the Query
8:46 - Outro

Connect With Me -

#coding
#leetcode
#mysql
#sql
#interview
#sqlinterview
#sqlinterviewquestionsandanswers
#sql_server
#learnwithchirag
#monthly
#transaction

[learnwithchirag]

Hey there! 👋 For more interesting content, tutorials, and updates, Feel free to connect with me on


Instagram Handles :-



Let's stay connected and keep the creativity flowing! 💡

[ashutoshrastogi]

Your videos are very informative, and good to learn and practice about the concepts of SQL....👍

[AdityaBhatt]

Can someone please explain why we do SUM() for approved trans count rather than COUNT()

[yashiktaneja]

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

[krishnabohidar]

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.

[shreyaraj]

Bhaiya, I tried writing COUNT( state = 'approved' ) as approved_count. But this doesn't work, only SUM works. Why is it so?

[jeevananuragi]

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?