LeetCode 1193: Monthly Transactions I

Solution and walkthrough of a real SQL interview question for Data Scientist and Data Analyst technical coding interviews. This question is marked as easy and is called "Monthly Transactions I".
Try this question: leetcode.com/p...
LeetCode SQL 50 Study Plan: leetcode.com/s...
Check out StrataScratch: www.stratascra...
Find me on LinkedIn: / frederikmueller
Playlists:
• StrataScratch Coding Q...
• LeetCode Database Prob...
• LeetCode SQL 50 Study ...
• LeetCode Easy Database...
• LeetCode Medium Databa...
• LeetCode Hard Database...

[@AceofSpades292]

Thank you for making these videos. It's especially helpful to see what patterns you recognize in the problem statements. Happy New Year!

[@frederikmuller]

I‘m glad it’s helpful. Happy new year! I’ll make a separate video on recognizing patterns.

[@HenggaoCai]

month is an alias.

[@frederikmuller]

I agree, it’s best to put it in quotes as it’s an SQL keyword for date formatting. In MySQL, it works without quotes.

[@HenggaoCai]

There is an extra parathesis.

[@frederikmuller]

yes, it’s left over from the previous calculation where I used another pair of parentheses