1193. Monthly Transactions I | Leetcode SQL Medium

Welcome to the Leetcode SQL series
#leetcodesolution #leetcode #sql

Link to the problem:

👉 Link to Dense_rank, rank, and row_number functions video:

👉 Link to the video on Database Design:

Visit my Youtube channel here-
Access the "SQL Interview Queries For Product-Based Companies" series playlist here:

[ShubhamGupta-uk]

Hey why SUM(CASE WHEN state='approved' THEN 1 ELSE 0 END) AS not --->COUNT(CASE WHEN state='approved' THEN 1 ELSE 0 END) AS approved_count. Can anyone help

[_RahulDewangan]

You just already know the query and write it, didn't properly explain how we can think in that direction while solving the question for 1st time